02-09-2024 05:10 PM
Hi Everyone,
We have multiple cubes in an application. Is there a way to retrieve the cube name using the entity dimension member. I have multiple entities in a excel sheet and I need to get the cube names for them.
I tried the =XFGetMemberInfo(memberInfoType,dimTypeName,memberName). It did not work.
Thanks
Solved! Go to Solution.
02-12-2024 08:39 AM
Glad you got it done @Jeevan. If SSMS isn't a choice, you can run the same query in a business rule and output the results to the Error Log.
02-09-2024 06:54 PM
Hi @Jeevan
Here's a query you can use, note that entities aren't always specific to as a single cube.
SELECT DISTINCT c.[Name] AS CubeName
FROM [dbo].[Cube] c
JOIN [dbo].[CubeDim] cd ON c.CubeId = cd.CubeId
JOIN [dbo].[Dim] d ON cd.DimTypeId = d.DimTypeId AND cd.DimId = d.DimId
JOIN [dbo].[Member] m ON d.DimId = m.DimId
WHERE m.[Name] = 'Total GolfStream'
02-09-2024 09:13 PM
Hi @RobbSalzmann ,
Thanks for the response. I do not have SSMS and access to the db.
I did manually pull the entities from the consolidated cube using quick view and used xlookup to get the cube details for the entities.
Thankyou.
02-12-2024 08:39 AM
Glad you got it done @Jeevan. If SSMS isn't a choice, you can run the same query in a business rule and output the results to the Error Log.