The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Harry's avatar
Harry
New Contributor III
3 years ago
Solved

Display in a Dashboard where a Member Name is used in the application (in which Cube 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 

Cubes
Metadata
Methodology
  • EricOsmanski's avatar
    EricOsmanski
    3 years ago

    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%'

4 Replies

  • EricOsmanski's avatar
    EricOsmanski
    Icon for OneStream Employee rankOneStream Employee
    3 years ago

    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%'

  • Harry's avatar
    Harry
    New Contributor III
    3 years ago

    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

    • EricOsmanski's avatar
      EricOsmanski
      Icon for OneStream Employee rankOneStream Employee
      3 years ago

      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.