December 27, 2005 at 12:49 am
Hi
Am a newbie to SQL server Analysis Services. I am using SQL 2000 and trying to get a hang on cubes/dimensions. I have created a cube already but when I try to process it I get a process failed error. However from the error description I cannot makeout what is the problem. I have the screenshot of the error msg in the below URL:
http://rapidshare.de/files/9890712/process_error.JPG.html
I would really appreciate if someone can help me out.
Thanks a lot,
Hari
December 27, 2005 at 6:03 am
At a guess I would say it's the unprintable characters that are causing you issues (see the 'boxes' in the string). It's hard to tell from the error message plus the image doesn't show the entire line.
Steve.
December 27, 2005 at 6:11 pm
December 27, 2005 at 6:32 pm
You should turn processing logging on (i think it's in the server properties). This will then let you get the SQL that's being passed to your data source. Assuming the datasource is MSSQL, take this sql string and paste it into Query Analyser and look through the results. Those 'squares' are unprintable characters and could represent carriage returns, tabs or something else.
Also check your cube/model design. It's good practise to use a key (preferably integer or similar) as the key for a level within a dimension and then set the name field appropriately. Assuming you are using a datamart or data warehouse, the fact table should have these keys within it (ie not the names), which in turn will let you optimise the schema, which basically changes the fact query to use the fields within the fact table rather than doing a large join query between the fact and all of the dimensional tables.
Steve.
December 27, 2005 at 7:35 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply