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