You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Pull metadata into AdHocs?

edited Dec 14, 2020 3:59PM in Planning 4 comments

Summary

Users want to be able to pull metadata (attribute values) into AdHocs

Content

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).   

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!