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

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.

Harry's avatar
Harry
New Contributor III
3 years ago

Thanks Eric 

Harry