Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Using Power BI as a CPM solution?

Hi, I'd like to know if anyone has used Power BI as a CPM solution and if yes by with which his features.   Thanks
General Comment
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

I am not familiar with CPM. What features would you like to get in Power BI?

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Lydia,

    a CPM solution allows to input budgeting data in the system; so, Power BI should allow to insert data.

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      You can  import required data from your data source to Power BI Desktop, then calculate budget using DAX in Power BI.

      Regards,
      Lydia

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Lydia,

        what you suggest it is a known forced workaround to remedy to the absence of the write-back feature. Nowadays, each Microsoft on-memory tabular technology (e.g. SSAS Tabular, PowerPivot, Power BI) hasn't a such feature, but it is present for SSAS multidimensional.

         

        Thanks

    • danextian's avatar
      danextian
      Super User
      8 years ago

      I remember seeing something similar with your requirement from a vendor's (poweronbi) showcase in last year Data insight Summit. Their tool is called Power Planner which has the ability to writeback to the database. Here's the demo:

       http://poweronbi.com/ppdemo/

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Danextian,

        but you talk about a solution implemented by a 3-rd party vendor and not a Power BI feature directly implemented by Microsoft.

         

        Thanks