Skip to main content
H
Harry
Newcomer
July 8, 2022
Solved

Display in a Dashboard where a Member Name is used in the application (in which Cube Views...)

  • July 8, 2022
  • 2 replies
  • 0 views

Hi,

Do you know if there is a way to display in a Dashboard where a Member name is used in the application (in which Cube Views...) ?

Thanks,

Regards,

Harry 

Best answer by EricOsmanski

Harry - you can put this query into a Data Adapter and then into a Dashboard. You can also make a parameter which will pop up and require an entry or allow the user to select the member.

SELECT Name
FROM CubeViewItem
Where XmlData LIKE '%YOURMEMBERNAME%'

2 replies

E
OneStream Employee
EricOsmanskiOneStream EmployeeAnswer
OneStream Employee
July 11, 2022

Harry - you can put this query into a Data Adapter and then into a Dashboard. You can also make a parameter which will pop up and require an entry or allow the user to select the member.

SELECT Name
FROM CubeViewItem
Where XmlData LIKE '%YOURMEMBERNAME%'

    H
    HarryAuthor
    Newcomer
    July 11, 2022

    Thank you very much Eric, 

    Do you know how to dipslay the cube views that contain a member even if the member is not memtioned explicitly, but through a business rule or an aggregate in the field "member filter" ?

    Thanks,

    Harry

    E
    OneStream Employee
    EricOsmanskiOneStream Employee
    OneStream Employee
    July 11, 2022

    You could search the BR's for the member name, but to see if it exists within a member filter would be something that needs to be built. I can imagine it being quite expensive because of all the checks that would need to be done, but it likely is possible. I don't have anything on this, though.

    H
    HarryAuthor
    Newcomer
    July 11, 2022

    Thanks Eric 

    Harry

    Terms & ConditionsAccessibility statement