This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 8%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
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!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
If, as the reference to role-playing dimensions implies, you have one database dimension and 15 cube dimensions based off it, tough. It's database dimensions that are linked to DSV items. You can't change DSV references at the cube dimension level.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
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.
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)....
Hi ,
Have you resolved the issue ? We'd be happy to know any further process or help needed.