Pull metadata into AdHocs?
Summary
Users want to be able to pull metadata (attribute values) into AdHocsContent
We have 13 attribute dimensions against our entity dimension, and the users would like to see the assigned attribute next to the member in a grid. We can do that for smaller attribute dimensions with "indicator" account members with dynamic calc formulas and smart lists.
But what about big dimensions?
In this case, users would like to pull the "Customer" next to each entity. There are 3,000 bottom level stored members in the Entity dimension, and 1,500 unique customers.
Is that possible?
I cannot put the Customer in an alternate alias table, because some customers are related to many entities, and would not be unique (nor do I really want to make them unique because users want to do lookups and correlations).
0