Interview Question #3: Converting a Consolidation to a Custom Group

Question

Can you always convert a consolidation to a custom group and vice versa?

Answer

You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables.

2 responses

  1. Is there any performance issue occur when defined the elements from different dimensions on consolidation? example: {Account=1 and Customer=A and product=P1} + {Account=2 and Customer=B and product=P2} … so on

  2. Torben Westergaard | Reply

    Not that it has any practical significance, but a consolidation element can specify that the metric values for, say, New York and Chicago should be multiplied. I don’t see how you can do that with a Custom Group.
    Cheers, Torben

Leave a Reply to Mahendrakumar Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: