The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Drill down Chart in BI Viewer.
Hi
I have a problem with dril Down in BI Viewer.
Part of our UD1 is as follows:
BU1000 - EGMONT GROUP
BU1500 - Other Business line
...
Hi
I have finally found a solution that is working. Thanks for the help.
Definition of Column in Cube View:
It is important to use Base. I this case ”Where(Text7=’ ’)” is used to exclude joint ventures and associates.
Definition of Row in Cube View:
IMPORTANT: It does not work using TreeDescendantsInclusiveR
Data adapter:
As Columns is base only use Outermost Row. It will only work if I loop on UD1.
Bi Viewer:
I have made a calculated field with RecOK with the formula: iif([Amount]<>0,'Value','Zero'). By this I can remove all companies with no amount in the drill down.
The chart has the following filter:
The UD1 levels should be sorted on amount:
After sorting in reverse orden the graph looks like this. I can now drill down to sublevels in UD1 and finally end in a specification on Entity.
hmm, why are you looping on UD1 if you already got all UDs in the cubeview?
Hi
I realy appriciate your help. As I am quite new into OneStream I have tried several solutions without the wanted result. As I understand it now is that if I use TreeDecebtabtsInclusive in cube view I do not need to loop in dataadapter. I have tried to use AllUD1 in cube view and loop in dataadapter with no succes.
[EXTERNAL URL LINK REMOVED]
Important places:
- Starting with Cube View, and settings for UD1 and Entity.
- After 20 seconds the dataadapter. No Loop but Dimension to Level set to Outermost Row
- After 44 seconds BI Viewer with dummy values (no difference if it were running in a dashboard). As you can see in the orange box the total for BU1500=BU6000=BU6100 should be approx 12.6M kr.
- After 1:16 I have two bars. The one with orange number 1 should not be there as it is a subtotal. BU6000 should be 12,6 but it adds BU6000+BU6100 and therefore giving 25,3.
- After 1:30 I have drilled down and have two bars. The one with orange number 1 should not be there as it is a subtotal. BU6100 is correctly 12,6.
- After 1:42 I am at the lowest level and it is giving me entity names.
MGOneStream Employee
Hi there.
I would recommend you raise a ticket with the support team as they will be able to share a screen with you to take a look at the issue and provide some advice/ help as necessary.
Thanks