Skip to main content
D
donald_thib
Newcomer
February 14, 2022
Solved

Use attributes dimensions in a cube view

  • February 14, 2022
  • 2 replies
  • 0 views

Is it possible to use data from attributes and attribute values in a cube view row or column filter?

    Best answer by ckattookaran

    Are you asking about the stage attributes? Or talking about attribute dimensions? If it is the stage, then you could use relational blending. Yes, you are going to create dynamic members to do this. I did write a post on relational blending here.

    https://cpminsights.com/2019/08/26/nuts-and-bolts-of-relational-blending-in-onestream/

    Or you could take a dashboarding approach where you present this information only in a dashboard. An example is here.

    https://cpminsights.com/2019/09/09/show-stage-attributes-in-onestream-using-drill-through/

    2 replies

    A
    Avatar-Roku
    Newcomer
    February 14, 2022

    Just found something similar answered by EricOsmanski --

    https://community.onestreamsoftware.com/t5/Reporting/How-to-bring-attribute-quot-Text-quot-fields-value-into-a-Cube/td-p/4815

    I'm thinking - by using the method mentioned above. You build a dynamic calc, and reference that in your CV rows/column. 

    Open to any other people's ideas/suggestion. Thanks!

     

    Best,

    Mustafa A

    D
    donald_thibAuthor
    Newcomer
    February 14, 2022

    Thanks Mustafa_A but, the referenced link is pulling the data from a one of the Entity dimensions Text fields from one of the stage attribute fields. I'm thinking a custom member may be my only solution here but, I would like to hear if there are other options.

     

    D
    donald_thibAuthor
    Newcomer
    February 14, 2022

    Thanks Mustafa_A but, the referenced link is pulling the data from one of the Entity dimension's Text fields. I need to retrieve data from one of the stage attribute fields. I'm thinking a custom member may be my only solution here but, I would like to hear if there are other options.

    C
    ckattookaranAnswer
    Newcomer
    February 15, 2022

    Are you asking about the stage attributes? Or talking about attribute dimensions? If it is the stage, then you could use relational blending. Yes, you are going to create dynamic members to do this. I did write a post on relational blending here.

    https://cpminsights.com/2019/08/26/nuts-and-bolts-of-relational-blending-in-onestream/

    Or you could take a dashboarding approach where you present this information only in a dashboard. An example is here.

    https://cpminsights.com/2019/09/09/show-stage-attributes-in-onestream-using-drill-through/

      Terms & ConditionsAccessibility statement