Cube Views

PFowler
New Contributor

I have this cube view that I'm building to mimic a report that I'm doing. Each row of this cube view uses an aspect of the UD-1 base member. Such as PE, Description, Name etc. How do I get my cube view to populate different elements of the same user dimension on each row? The picture below gives an example. 

 

UD1 Dimension example.png

2 REPLIES 2

db_pdx
Contributor III

Hi PFougere: "Each row of this cube view uses an aspect of the UD-1 base member" what are the values that you are retrieving?  Are these things that can go into a hierarchy?  Or should they be split into different dimensions? If I am understanding your post correctly, I am concerned you split a single member's attributes into multiple base members.

My initial thinking is that you need to either split into more dimensions, or just move some of these aspects into the text metadata fields. Can you provide a few example rows?  That will help with making a suggestion.

Cheers    -DB

PFowler
New Contributor

 I figured it out thanks for helping