Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm struggling to figure out how to resolve a synthetic key issue. The context of this issue is that I'm attempting to create a dynamic pivot table with the following selection options as list boxes. I figured out how to achieve the list boxes, but I can't figure out how to populate the dynamic pivot.
My main issue is that all of the business areas share the same metrics & dimensions. Thus, my entire table is connected by a number of synthetic keys. Here is the key view after I tried to resolve the issue by qualifying each table. However, that won't resolve my problem because I need to associate each dimension & metric between the 10 business areas.
Is anyone able to point me in the right direction? Do I need to create a link table, or concatenate the common dimensions & metrics (even though they are shared by all of the business areas)?
Best,
AR
Concatenate all the business area into a single table with flag for each business area.
In your expression you can use the flag to determine which business area.
This would help
Rupam,
Thanks for the response. Can you go into more detail regarding flags?
Load
*,
'ABC' as Business Flag
From XYZ where business='ABC'
Concatenate
Load
*,
'FGH' as Business Flag
From ZYX where business='FGH'
Avoid Duplicate thread plz