Skip to main content
P
PFowler
Newcomer
October 4, 2022

Cube Views

  • October 4, 2022
  • 2 replies
  • 0 views

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

D
db_pdx
Contributor
October 4, 2022

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

P
PFowlerAuthor
Newcomer
October 6, 2022

 I figured it out thanks for helping 

Terms & ConditionsAccessibility statement