07-08-2022 07:53 AM - last edited on 05-03-2023 09:17 AM by JackLacava
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
Solved! Go to Solution.
07-11-2022 11:14 AM
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%'
07-11-2022 11:14 AM
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%'
07-11-2022 12:28 PM - edited 07-11-2022 12:30 PM
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
07-11-2022 12:31 PM
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.
07-11-2022 12:34 PM
Thanks Eric
Harry