Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BhaskarDasari
Starting Member
19 Posts |
 Posted - 2008-10-14 : 03:05:43
|
| i have migrated 2000 cubes to 2005 using migration wizard which will get with sql server itself.But getting lot of issues. so i decided to use another migration tool .please let me know the various free migration tools available in the market and if possible give the links to install and use.Any help would be appreciated...Thanks in Advance..Bhaskar |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-14 : 03:08:55
|
What are the issues?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
BhaskarDasari
Starting Member
19 Posts |
Posted - 2008-10-14 : 03:32:44
|
| peso,for few dimensions,all members are not populated properly.let me explain u with my current dimension:dimension: emp engagemeent summaryattributes: business,division,subdivision,subsubdivision, subsubdivisionid.hierarchy: business->division-->subdivision->subsubdivisionFor achieving drilldown i have established attribute relationships for subsubdivision like subsubdivision-->business->division-->subdivision.when i process and browse dimension i am missing few subsubdivisions.if i use subsubdivisionid in hierarchy, i will get all the subsubdivisions but drilldown will go off and doesnt give results expected in cube as well.why this is happening like that.if u want i will send u screeshots , give me ur mail id. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-10-14 : 03:56:09
|
Are the subdivisions used? Did you process only used dimensions?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
BhaskarDasari
Starting Member
19 Posts |
Posted - 2008-10-14 : 05:22:26
|
| subdivisions which are missing are not used but they should be displayed in browser..i processed all the dimensions. |
|
|
|
|
|
|
Migration tool for upgrading 2000 cubes to 2005 cu