SSAS MOLAP. How to change dsv source of cube dimension

jon strauss 1 Reputation point
2020-09-11T14:25:53.233+00:00

Hello there.
SSAS MOLAP question.

I originally created a single date table in the dsv and derived multiple role playing date cube dimensions from this. Works fine but then i found out from the business that each date dimension needs a different subset of dates (structure stays the same, but view just restricts the data)

So I added the views to the DSV. I then thought I would be able to change the data source of the cube dimension so i wouldn't have to recreate them but it's all disabled. I dont want to recreate them again, as there are 15 date dims and there are multiple hierarchies (not the same for each).

So I then thought i'd be able to go into the cube xml file and change the source name from dim_date table to new_dim_date_view but i can't find how to do this. The cube file has no references to the original date table i want to change for that cube dimension. Am I looking in the wrong file?

Any ideas how to do this? The structure of the dims are identical, it's just the number of rows that differ, so i thought i'd just be able to swap the table name to the new view (easy i thought).
Thanks a lot!

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,247 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-14T08:20:11.187+00:00

    Hi,

    Not quite clearly understand what your need here :

    So I added the views to the DSV. I then thought I would be able to change the data source of the cube dimension so i wouldn't have to recreate them but it's all disabled.

    Could you add more detail or screenshot to explain what are you trying?

    So I then thought i'd be able to go into the cube xml file and change the source name from dim_date table to new_dim_date_view but i can't find how to do this.

    Based on my personal experience, it is not a very safe operation to directly change the XML definition file. For the Cube structure or other metadata we'd better use VS to do the job, useless we are very familiar with them.
    Regards,
    Lukas

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. jon strauss 1 Reputation point
    2020-09-15T12:33:35.907+00:00

    No worries but thx...sounds like it's just easier to recreate them. Realise the database dims are associated with the dsv but thought there would be something obvious in the xml to swap the source of the cube dims. But cheers for the replies....not the end of the world to start afresh with this (probably a days work)....

    0 comments
  3. Lukas Yu -MSFT 5,816 Reputation points
    2020-09-17T06:01:54.257+00:00

    Hi ,
    Have you resolved the issue ? We'd be happy to know any further process or help needed.

    0 comments