dbTalk Databases Forums  

Dimension log info

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Dimension log info in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Vardinghus
 
Posts: n/a

Default Dimension log info - 06-06-2005 , 04:07 PM






How come I don't get more to go on as an error message.

Have a time dimension from Accelerator with a normal time dimension and then
a virtual time dimension with a week hierachy.

When looking at the week hierachy dimension in dimension browser it looks
fine but when processing it in a cube it says:

06-06-2005 22:59:09 11680 Initiating transaction in Database 'UM_DW_Finance'
06-06-2005 22:59:09 11680 Processing Cube 'test dato' Start time:
22:59:09
06-06-2005 22:59:09 11680 Initializing Cube 'test dato'
06-06-2005 22:59:10 11680 Processing Partition 'test dato' Start
time: 22:59:10
06-06-2005 22:59:10 11680 Initializing Partition 'test dato'
06-06-2005 22:59:10 11680 Partition 'test dato' Execute : SELECT
"dbo"."Dim_Time_Day"."Day_Idx", "dbo"."datotest"."test" FROM
"dbo"."datotest", "dbo"."Dim_Time_Day" WHERE
("dbo"."Dim_Time_Day"."Day_Idx"="dbo"."datotest"." dato")
06-06-2005 22:59:10 11680 Analysis Server Error: Internal error
[Object does not exist] '04-01-1998' ; Time:06-06-2005 22:59:10
06-06-2005 22:59:10 11680 Analysis Server Error: Internal error
[Object does not exist] '04-01-1998' ; Time:06-06-2005 22:59:10
06-06-2005 22:59:10 11680 Processing Partition 'test dato' failed.
No changes have been made to the database.
06-06-2005 22:59:10 11680 Processing Cube 'test dato' failed. No changes
have been made to the database.
06-06-2005 22:59:10 11680 Rolling back transaction in Database
'UM_DW_Finance'

Then tried to make a new physical dimension with the same levels wich seams
to work...don't understand why the virtual didn't - it worked in
accelerator...and I don't know where to look based on the above...



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.