SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Unpopular SELECT Statement


The Unpopular SELECT Statement

Author
Message
neomal
neomal
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 3
This is a nice article... powered by hands on experience....
it helps to get abasic idea about some data werehousing aspects...
Credit for the author
s_bohari
s_bohari
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 70
Hi guys,
I have a similar problem as Steven, when it comes to restoring a OLAP database. I'm trying to restore the database to another computer then the one I toke the backup from. The error message is similar to this one:

"The ddl2:MemberKeyUniqueElement at line 97, column 10600 (namespace http://schemas.microsoft.com/analysisservices/2003/engine/2) cannot appear under Load/ObjectDefinition/Dimension/Hierarchies/Hierarchy.
Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\c:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Sales2.0.db\Dim Date.1.dim.xml'.
Errors in the metadata manager. An error occurred when loading the Sales cube, from the file, '\\?\c:\Program Files\Microsoft SQL ServeMSSQL.2\OLAP\Data\Sales2.0.db\Sales.2.cub.xml'. (Microsoft.AnalysisServices)"

The dimensions and cube is not the same, obviously.

Anyone got a solution to the problem? I might have to add that this orginally was a totally SQL 2008 project (SSMS & BIDS 2008), which I'm running on a SQL 2005 database engine with BIDS 2008.

Thankful for all possible help!

Regards,
VincentRainardi
VincentRainardi
SSC Veteran
SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)

Group: General Forum Members
Points: 291 Visits: 191
Hi, try scripting the AS database on the old AS server to XMLA then run the XMLA script on the new AS Server to create the AS DB.
Change the data source if necessary (to point to the new relational engine), process the AS database and browse it.
HTH,
Vincent
s_bohari
s_bohari
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 70
Hi Vincent,

I found the solution to my problem on another website. I needed to check that SQL Server 2005 SP2 is installed on the source/target server, if not install it.

I tried your solution before installing the SP2, but during execution it failed.

Thank you for your help.

Kind regards
peter-757102
peter-757102
Right there with Babe
Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)

Group: General Forum Members
Points: 799 Visits: 2559
A nice basic introduction!

I myself have wrestled with AS2005 in practice and seeing how easy others run into problems given all the post here are about just that, I get heavy Deja Vu. Some things are good but from a modeling, querying and maintainability point I never accepted AS2005 as a finished product (not even as beta in fact).

All I can say is that if you are interested in digging deeper into multi-dimensional modeling, be prepared to have major setbacks on anything but the most basic examples. Spacial thinking and reasoning in 5 dimensions (so along 5 axis) and more is pretty straightforward if you know multi-dimensional arrays from programming or have done complex queries in SQL within a star diagram.

After all you don't need to visualise the dimensions to understand them and you don't need to perform rotations and other complex geometry within that multi-dimensional space to collect meaningful data. That would realy be impossible for all but maybe 2 humans on this planet that can deal with 5 dimensions without computerised visualisation assistance.

The often untold truth is that AS works nothing like all examples let you think. Also prepare for the case that a lot of information you read is likely to contain mistakes or has contradictions with other sources of information and instead of help they can just as easily put you on the wrong track.

At least this is what I found a few years back when I had a solution that worked well in SQL and I understood in full. The project was to move all the data into AS2005 so reporting would become easyer for the customer as they could use their own tools instead of using our application. The story ended with sticking to SQL for reporting as having user readable reports contradicted with the requirement of querying the same data via MDX to get application interpretable table (2D) results.

I won't spoil the exercise, just make sure you understand every step of the way and do heavy testing. Query results can become quite deceiving in that things seem to work, but turn out not to under certain conditions. Logic the way you are used to in SQL does not apply when it comes to MDX!

I am bound to get some flak over this by AS folks, but even people I asked that *know* had to guess a lot of the time. They just try it in a data browser and if the answer seems ok, they accept it as working...not good enaugh for me I am afraid.
Half Bubble
Half Bubble
SSC Veteran
SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)

Group: General Forum Members
Points: 244 Visits: 168
Who ate the figures?

All I get is blue boxes Crying

Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.

sanjarani
sanjarani
SSC Journeyman
SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)

Group: General Forum Members
Points: 90 Visits: 296
I enjoyed reading this article, thank you. I have been using SQL Server 2005 for a couple of years now, in particular SSIS and SSRS. However, I have not used SSAS so far, because the work that I have been involved in did not require the use of SSAS. If I were to start learning SSAS, would your book be a good starting point or is it too advanced for a beginer? I don't know the MDX language, but am a very confident T-SQL developer.
By the way, unlike some of the readers who could not download the database and restore it, I restored the database and viewed and queried the cube as per your instructions with no difficulties.
vchintapanti
vchintapanti
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 18
How to AUTOMATE the process and deployment of the CUBE when new data added to the FACT and DIMENTION table.
Alan Vogan
Alan Vogan
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1159 Visits: 585
Vincent, Nice Article Smile

And an excellent discussion posting. We often put on our 'Analyst Hat' and dive into things before we've put on our 'Systems' or 'DBA' hat to actually get a project set-up. I know I often find my self going back, saying to myself 'Whoops, forgot to set that up!, Whoops, need SP2 update 6.' etc. etc. etc.

That's why we're not brain surgeon's... w00t

All good notes for you for the next edition Wink

peace,

Alan
VincentRainardi
VincentRainardi
SSC Veteran
SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)

Group: General Forum Members
Points: 291 Visits: 191
All, thank you for all your comments. Sanjarani, for learning SSAS my book is not the right one. My book is about building a data warehouse and BI, so the coverage on SSAS is very limited. To learn SSAS, it is better to read 2008 books rather than 2005 ones, because of the improvements in SSAS 2008. Irina Gorbach, Edward Melomed and Alexander Berger are reknown expert in SSAS and I'm grateful that they spared their time writing a good SSAS 2008 book (0672330016), which I enjoyed a lot. Another good SSAS book is Sivakumar Harinath and Robert Zare's (0470247983). Although it is in 2005, Teo Lachev's book (0976635305) is extremely structured, and will be a great help to anybody starting SSAS journey.
vchintapanti, to automatically process (refresh) the cube when new data is added in the data warehouse, we can either use a ROLAP partition, or use ProActive Caching. http://msdn.microsoft.com/en-us/library/ms174769.aspx explains the considerations.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search