Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

export cube details to excel sheet?

I have several tabular cubes (.bim files) where I am trying to do some documentation in excel.

 

I would like to find a way to automatically export for a given cube:

 

  • Column name (cube level)
  • Column name (source level)
  • Table name (cube level)
  • Table name (source level)
  • Measure with corresponding dax code.

 

 

Is there a way I can get all these values with a single click, rather than building it myself by constantly copy pasting to excel?

Need Help

1 Reply

  • timg's avatar
    timg
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Ovonel,

    I personally like using DMV's (dynamic management views) for this purpose. These contain all sorts of information about your data model and could be used in an export to excel or Power BI. Here's the full list of available DMV's: Dynamic Management Views (DMVs) in Analysis Services | Microsoft Docs 

    The TMSCHEMA_COLUMNS, TMSCHEMA_TABLES and TMSCHEMA_MEASURES will likely contain most of the information you're looking for. 

     

    Best regards,

     

    Tim