Forum Discussion

Ole_S_P's avatar
Ole_S_P
New Contributor II
4 months ago

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       ...
BI Viewer
Cube View
Dashboards
  • Ole_S_P's avatar
    Ole_S_P
    3 months ago

    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.

     

     

     

ckattookaran's avatar
ckattookaran
VIP
4 months ago

hmm, why are you looping on UD1 if you already got all UDs in the cubeview?

  • Ole_S_P's avatar
    Ole_S_P
    New Contributor II
    4 months ago

    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.

     

     

     

     

     

    • MG's avatar
      MG
      Community Manager
      4 months ago

      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