Forum Discussion

OSC's avatar
OSC
Frequent Visitor
7 years ago

Export Table definition and Custom Columns to another PBIX

Hello Community, I have looked around but did not find a proper answer to how I could move the Table definition and its subsequent Custom Columns from one pbix to another...   The only similar q...
Need Help
bihumano's avatar
bihumano
Icon for Helper I rankHelper I
2 years ago

run this on Data Studio:

 

--All Cubes in database
SELECT [CATALOG_NAME] AS [DATABASE],CUBE_CAPTION AS [CUBE/PERSPECTIVE],BASE_CUBE_NAME
FROM $system.MDSchema_Cubes
WHERE CUBE_SOURCE=1
 

--All Attributes
SELECT [CATALOG_NAME] as [DATABASE];
CUBE_NAME AS [CUBE];[DIMENSION_UNIQUE_NAME] AS [DIMENSION];
HIERARCHY_DISPLAY_FOLDER AS [FOLDER];HIERARCHY_CAPTION AS [DIMENSION ATTRIBUTE];
HIERARCHY_IS_VISIBLE AS [VISIBLE]
FROM $system.MDSchema_hierarchies
WHERE CUBE_NAME ='Model'
AND HIERARCHY_ORIGIN=2
ORDER BY [DIMENSION_UNIQUE_NAME]

 

 

found more on this link : https://bennyaustin.com/2011/03/01/ssas-dmv-queries-cube-metadata/