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

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