Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

SSAS Multidimensional to SSAS Tabular Migration and getting this error Message

Hi All,

I am trying to convert a very basic SSAS Multidimensional cube to SSAS Tabular.

 

SSAS Multidimensional Implementation:

2 fact tables: FactLedger and FactBudget 

2 dimensions tables. DimLedgerCombination and DimAccount

 

On Dimension Usage Tab: 

  1. FactLedger & DimAccount has regular relation on column AccountID and FactLedger & DimLedgerCombination has regular relationship defined on Column IdLedgerCombination.
  2. FactBudget & DimLedgerCombination has regular relation on Columns IdLedgerCombination & RecID but FactBudget & DimAccount has Referenced Relationship and here intermediate table is DimLedgerCombination.
  3. There is a relationship defined between DimLedgerCombination and DimAccount in SSAS DSV based on Column AccountID. So basically It is Snowflake Schema in which DimAccount is linked to DimLedgerCombination and DimLedgerCombination is linked to Fact tables.

 

When I tried converting this to Tabular getting an error message: "Failed to Save Modifications to the Server. Error returned: There are ambiguous paths between FactLedger and DimAccount"

 

Then to solve this issue in tabular, I removed direct link between FactLedger and DimAccount and creaed a 1 to many relationship between DimAccount and DimLedgerCombination based on column AccountID. 

 

 

Just wanted to check this is right approach?

 

There are other options to replicate this Scenario in SSAS tabular..?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    You could check the Issues forum here:

    https://community.powerbi.com/t5/Issues/idb-p/Issues

    And if it is not there, then you could post it.

    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.