August 11, 2014 at 3:40 pm
Hi All,
I need some advice here. We have a cube (owned by another team) which hosts all the essential data that we need. Our team currently uses a BI tool which doesn't work as well as we hoped with the cube's hierarchies etc.
We are thinking to ETL the cube's data into a SQL Server Relational database (using SSIS) which works very well with the BI Tool. Here comes my questions:
1) Is this a reasonable solution to approach this problem?
2) I have done some research on the ETL, some say this can be done using MDX + OLEDB Tasks, is this the easiest way to approach this?
3) Any better suggestions?
Thanks,
Alan
August 12, 2014 at 8:49 am
I think it would be better to ask yourself if you are using the correct BI tools for your needs or if you need to level up MDX skills before taking such a drastic step. If the hierarchies aren't working with your tool then I would suggest speaking to the team responsible for the cube so they have a better understanding of what you are doing and make any changes if needed.
It's possible to get data out of a cube and into SQL using openquery and a linked server easily enough, but I would suggest a more holistic approach is needed. Without knowing what tools you are using and what for, it's difficult to make a suggestion of another approach.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply