dbTalk Databases Forums  

Shared dimensions after cube migration...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Shared dimensions after cube migration... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
GB
 
Posts: n/a

Default Shared dimensions after cube migration... - 06-28-2006 , 12:47 PM






Hello,
I have 3 cubes with 3 shared dimensions (dates, ids, factors) in SQL Server
2000 environment. After the cubes migration to SSAS 2005
using Analysis Services Migration Wizard I got individual dimensions for
each cube : dates, dates1, dates2, ids,ids1, ids2, factors, factors1,
factors2. This makes the problem for my the cubes MDX queries and based on
it applications.
The question is how to preserve shared dimensions during cubes migration?

Thanks,
GB



Reply With Quote
  #2  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: Shared dimensions after cube migration... - 06-29-2006 , 02:17 AM







Hi

Such behaviour of the Migration Wizard is oddly. Usually (as a rule) all
Shared dimension are migrated 1:1. Only the virtual dimensions

Could you please tell us what specific do you have in your AS 2000 cube?
If your AS2000 cube isn't commercial secret, post it to the newsgroup
(naturally, empty, without data).

Thanks,
Vladimir Chtepa

"GB" <v7v1k3 (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:Wgzog.83340$I61.25475 (AT) clgrps13 (DOT) ..
Quote:
Hello,
I have 3 cubes with 3 shared dimensions (dates, ids, factors) in SQL
Server
2000 environment. After the cubes migration to SSAS 2005
using Analysis Services Migration Wizard I got individual dimensions for
each cube : dates, dates1, dates2, ids,ids1, ids2, factors, factors1,
factors2. This makes the problem for my the cubes MDX queries and based on
it applications.
The question is how to preserve shared dimensions during cubes migration?

Thanks,
GB





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.