Skip to main content
J
Jeevan
February 9, 2024
Solved

How to retrieve Cube name for an entity?

  • February 9, 2024
  • 2 replies
  • 2 views

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

 

Best answer by RobbSalzmann

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.

2 replies

R
RobbSalzmann
February 9, 2024

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'

 


RobbSalzmann_0-1707522767851.png

 

J
JeevanAuthor
February 10, 2024

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.

R
RobbSalzmannAnswer
February 12, 2024

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.

Terms & ConditionsAccessibility statement