How to retrieve Cube name for an entity?

[Jeevan]

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

[RobbSalzmann]

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'

[Jeevan]

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.

[RobbSalzmann · Accepted solution]

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.