May 6, 2011 at 1:40 pm
Hi,
We are using SSAS 2000 cubes at my workplace. Reporting Tool we are using is Proclarity 6. Most of the business users use Proclarity Professional. The database used is Oracle. It is like a datawarehouse we use as a backend for SSAS cubes.
My question is if we would migrate cubes from SSAS 2000 to 2008R2, how much effort would that be? Will it be almost like rebuilding the cubes again? Will we still be able to use Proclarity for reporting. Or do we have to invest in a new Reporting tool.
Please suggest.
Thanks and Regards,
Praveena
May 8, 2011 at 1:41 am
You can use the SSAS migration tools - but you generally end up in a bit of a mess:
1. the cube translation does not necessarily produce cubes optimized for 2008. This is especially true for Virtual cubes - which are sort of deprecated in 2008 for a completely different approach (linked cubes).
2. the 2000 cube structures do not reflect the more advanced ideas and technologies in 2008, so you'll be creating objects that do not take full advantage of the 2008 architecture and technology. The UDM and new hierarchy structures are the best examples here.
After having done this a few hundred times (well almost anyway!) I would STRONGLY recommend a native build in 2008. This does not require a change in the relational. Instead, with a few hours of elbow grease and a relatively simple learning curve, you can convert almost any cube from one system to the other.
As for reporting technologies, ProClarity 6.x will work fine with SSAS 2008 - although it can only effectively use the MSOLAP 9.0 drivers and does not account for some subtelties in the new MDx engines (noticed with the ProClarity totalling engine for example).
The use of the latest MSOLAP 10.0 drivers introduces real query and application bugs in Proclarity. That of course doesn't include OS compatability issues: ProClarity does not play well with 64-bit OS's and is becoming more and more antiquated when interoperating with things like Office 2010 etc.
If you're looking to keep the Proclarity framework you have invested in and still take the leap into the future, check our Pyramid Analytics - a product that feels like Proclarity and is backwards compatabile with ProClarity content. It also has some new nifty features and functions!
😎 snap
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply