SSAS Multidimensional to SSAS Tabular Migration and getting this error Message

[Anonymous]

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..?

[Anonymous]

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.