Skip to Content
0

Universe - How to model table aggregation and basic lookup to other table

Feb 07 at 07:13 AM

29

avatar image

Good Day BI Experts,

I got the requirement to create a report based on two ERP tables that should show two things:

Outputs an aggregated key figure (total costs) from one table that has several entries (several costs per cost location) and it should display from another table one key figure that has only one entry (Overall cost plan per cost location) – so aggregation and then basic lookup in another table.

What is the best way to achieve that in a universe / webi report?

Joining the two tables will join in the cost plan several times (for every record in cost table). Should I use the average function on the cost plan figure to overcome that or is there a better way modelling that (dim merge in the webi Report)?

Many thanks in advance for some advice.

Axel

idt
10 |10000 characters needed characters left characters exceeded

corrected the tag.this question is not related with business object platform.Please select the correct tag in future.

Can you please expalin with the diagram.

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Axel Radack Feb 08 at 02:02 PM
0

Attached example for question


Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Feb 08 at 02:22 PM
0

It's look like if you join on Cost location between two tables and create measure objects for actual & plan will work.Cost element is anyway in the table but not required in the final report.

How many records do you have in both tables? If records volume is very high in both table then report will take more time to refresh. in that case you create two webi queries and use merge dimension at report level.

Share
10 |10000 characters needed characters left characters exceeded
Axel Radack Feb 09 at 06:54 AM
0

Hi Amit,

but the join will produce wrong figures for plan as it will be joined for every cost elment - or do I miss something?

Best regards,

Axel


Share
10 |10000 characters needed characters left characters exceeded