Forum Discussion

miked's avatar
miked
Contributor
3 years ago

Displaying Text Values in Cubeview

Hi All,   I am wondering if there is a way to display a text value in a cube view cell directly from a cubeview member filter?  In other words, in the same way that you can use a member filter wi...
Cube View
  • brooney's avatar
    brooney
    3 years ago

    HI Mike,

    The best way to achieve this would be to create a dynamic member (maybe in the Flow/UD8 dimension) that tells it what to pull (could be logic, could just be 'Return "Hello"'. You would then put that on your CubeView row/column with a view of Annotation (V#Annotation:UD8#Dynamic_Hello).

    Thanks,

    Brian

brooney's avatar
brooney
New Contributor II
3 years ago

HI Mike,

The best way to achieve this would be to create a dynamic member (maybe in the Flow/UD8 dimension) that tells it what to pull (could be logic, could just be 'Return "Hello"'. You would then put that on your CubeView row/column with a view of Annotation (V#Annotation:UD8#Dynamic_Hello).

Thanks,

Brian

  • miked's avatar
    miked
    Contributor
    3 years ago

    yes agreed.  I was just hoping we could do this all from the cubeview to prevent setting up UD8 members to hold dynamic accounts.  Ultimately, we are looking to provide a report of all of the metadata and all of the member properties for each dimension and we like the way it presents in a cubeview.  However, to achieve this we need to display text values and wanted to avoid setting up a ton of member in the UD8 dimension.

     

    My guess is it's a typo in the documentation where it says the XFMemberProperty works with the GetDataCell function.  I don't believe it's correct.  Oh well, if anyone else has any ideas about this let me know.

     

    Thx,

    Mike