Dataviews - selecting and summing 70 accounts in a COA

Brady Knudsen

Alexander Kappes

Dear Brady Knudsen,

 

thanks for your request.

 

Without any knowledge of your problem, another option without using 70 or more blocks can be using aggregation of your actual COA Hierarchy.

 

For example you can insert an aggregation entity for COA lets say COA Group.

 

Inside this you manage the relationships like the example shows for my demo environment:

 

 

When you have something similar inside your database you can select your screen on aggregation level and just insert the cube twice to your layout (one with prior period or period offset, ..., and one time with the actual period.) 

 

Hope it helps

 

regards

 

Alexander Kappes

Dietmar Jeschkeit

Hi Brady Knudsen,

 

what about selecting the 70 accounts in a dataview and using the existing cube twice. First one is with function previous period value (block a) and second one is original (block b). With an algorithm b-a you get the movement.

 

Or do you want to see the 70 accounts by row, too ?

 

Helping get better with more Information.

 

BR

Dietmar

Brady Knudsen