locked
Can I get definition Text of Model ? RRS feed

  • Question

  • Can I get definition Text of Model ?

    I want to get my Power Pivot Model as Text,
    Table / Relation / Hierarche / calcurated columns.
    Like Power Query definition can get as Text by Power Query/M language.

    Text can use to new Power Pivot Model, customize , management, versioning, share.

    Regards,
    Yoshihiro Kawabata

    Tuesday, September 24, 2013 2:03 AM

Answers

  • Hello Yoshihiro,

    I wrote a TechNet Wiki Article on how to query PowerPivot DMV from VBA, you can find it here: Query Power Pivot DMV's with VBA

    When you query the DMV's for dimensions, hierarchies, measures and so on, you can create a kind of textual documentation about the PowerPivot cube design. E.g. for measures it will look like (shortened):


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, September 27, 2013 4:06 PM

All replies

  • Can I get definition Text of Model ?

    Hello Yoshihiro,

    How exactly should the result look like? Would the result of the DMV like
    MDSCHEMA_DIMENSIONS Rowset
    MDSCHEMA_HIERARCHIES Rowset
    MDSCHEMA_MEASURES Rowset
    etc as tables in Excel be fine for you?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, September 24, 2013 8:16 AM
  • Hello Olaf,

    Look like 1. SQL Server OLAP DML,
    Look like 2. Excel Power Query / M,

    Regards,
    Yoshihiro Kawabata.

    Tuesday, September 24, 2013 11:29 AM
  • Yes, looks like; but you can query in this way informations from a SSAS / PowerPivot cube.

    So, so are the informations of your interest and table format woulöd be fine?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, September 24, 2013 12:33 PM
  • Hello Yoshihiro,

    I wrote a TechNet Wiki Article on how to query PowerPivot DMV from VBA, you can find it here: Query Power Pivot DMV's with VBA

    When you query the DMV's for dimensions, hierarchies, measures and so on, you can create a kind of textual documentation about the PowerPivot cube design. E.g. for measures it will look like (shortened):


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, September 27, 2013 4:06 PM