December 9, 2010 at 2:33 pm
All,
I've been asked to modify a few cubes to change the names of 4 dimensions so that they are displayed to the user in a more friendly format in the client's BI tool. It's not possible to change the names in either SSMS or BIDS (or is it?), so I had to perform the following steps:
1. Back up the SSAS DB ("Prod")
2. Restore the backup to a new DB ("Dev")
3. Open the "Dev" DB in BIDS
4. Delete the 4 dimensions
5. Add the 4 dimension back and give them the preferred names
6. Reprocess all the dimensions
7. Reprocess the cube(s), one at a time.
The first cube, with only 1 fact table, reprocessed successfully. The 2nd cube, which has 2 fact tables, is giving me the following errors:
"The dimension was not found in the cube when the string was parsed."
I opened the "Prod" cube in a separate BIDS session and viewed it side-by-side with "Dev". Both fact tables have keys to the 4 dimensions that I modified. The "Dev" cube DSV shows links from the 2nd fact table to the 4 dimensions; however, the "prod" cube DSV does not.
The question I have is why are the relationships showing up in "Dev" but not in "Prod"? And, is there any way to remove the relationships in the cube only?
TIA,
Mike
December 10, 2010 at 8:55 am
The relationships in my cube seem based on the DSV relationships I set up. When I right-click those lines, they give me the option of editing the DSV.
When you redid the Dimensions, did you allow it to link tables? Did you have it do any autobuilding at all?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply