Detail-by references disappears when using conditional algorithm based on entity.

Malav Shelat

Hello Team,

I have a Dataview Layout as this

Under axis I have these entities:

and under data i have these:

Content D, E and F have References by (div-dept, sample image shown below)

All are cube and algorithm contents,

For F Content , i have entered an algorithm (E-D) and under references i have detailed it by Different divisions,

like this,

i am getting a proper dataview, like this

Now what i want is for F algorithm as described above, if rows are Cost of Sales or Exp Expense is should calculate (D-E) instead of (E-D).

I know this is possible by applying entity in layout and using conditional algorithm on it but when i do that the Var column and References detail-by Column (by division) disappears, and i can just see the Actual and Budget columns.

like this,

and here is the resultant data-view

is there any work around to fulfill my requirement, is there any functionality i am missing out ?!

please guide ,

Regards,

Malav

Find more posts tagged with

Accepted answers

All comments

Alexander Kappes

Dear Malav Shelat,

just some questions.

When I see the layout with the entity and the Block "Hidden Cube for supporting B" that means that the Entity Block isn´t in relation to your axis?

Cost of Sales and Expense are Account Classes, correct?

For that case your dataview will never be valid, because Entities used as blocks can only show the entity content, when they are in direct relation to the deepest row entity.

To get your case work, you can insert your dimension into the axis or alternatively you can calculate with dataflows in procedures.

Hope it helps

regards

Alexander Kappes

Previous Member

Hello Alexander Kappes

"When I see the layout with the entity and the Block "Hidden Cube for supporting B" that means that the Entity Block isn´t in relation to your axis?

Cost of Sales and Expense are Account Classes, correct?For that case your dataview will never be valid, because Entities used as blocks can only show the entity content, when they are in direct relation to the deepest row entity."

Yes you are right, they aren't into relation and that's why this situation arises.

"To get your case work, you can insert your dimension into the axis or alternatively you can calculate with dataflows in procedures."

Could you please explain that a little bit more, i'll effort in to figure out the rest.

Much Thanks,

Malav

Alexander Kappes

Dear Malav Shelat,

well to get it work without calculation, you insert the dimension in best case as deepest row entity and can work with your if,...

The DataFlow (more complex), needs another cube, which later will be displayed inside your dataview and you calculate it in this way.

1. Selection for Account Classes Cost of Sales and Expenses

2. DataFlow: Temp Cube = d-e

3. Selection for all other Account Classes

4. DataFlow: Temp Cube = e-d

When you do this you can insert your Temp Cube inside your dataview and will see the correct figures without any algorithm or something else.

Which solution you take depends to your case and the effort you want to give for the solution. Because using the calcualtion you have to think about when it will be calculated (by opening the screen, by clicking button inside the screen, in the nightload, ...)

Hope it helps

regards

Alexander Kappes

Previous Member

Wonderful Alexander Kappes , Thank you very much for help and suggestion, will try fixing it now.