dbTalk Databases Forums  

Olap Processign is giving Error

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


Discuss Olap Processign is giving Error in the microsoft.public.sqlserver.olap forum.



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

Default Olap Processign is giving Error - 07-27-2005 , 02:26 PM






When refreshing my cube i am gettign this error.

A member with key 'IN HOUSE, SANDY SPRINGS-GA, SANDY SPRINGS-GA' was found
in the fact table but was not found in the level 'Ae Name' of the dimension
'Org'.; Time:7/27/2005 12:01:01 PM

My Dimension is
Org
Top Level
Division
Area
Region
GRP
CostCenter
AE Name

My Ae Nmae is a part of Fact Table.

Please help

Thanks
Tanweer

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Olap Processign is giving Error - 07-28-2005 , 12:13 AM






The system is telling you that a record with that key was found in the
database; but not in the dimension. That is a *very* strange key value. I am
absolutely positive that when you research this further you will find that
either indeed that key isn't in the dimension; or you've specified the wrong
field somewhere.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Tanweer" <Tanweer (AT) discussions (DOT) microsoft.com> wrote

Quote:
When refreshing my cube i am gettign this error.

A member with key 'IN HOUSE, SANDY SPRINGS-GA, SANDY SPRINGS-GA' was
found
in the fact table but was not found in the level 'Ae Name' of the
dimension
'Org'.; Time:7/27/2005 12:01:01 PM

My Dimension is
Org
Top Level
Division
Area
Region
GRP
CostCenter
AE Name

My Ae Nmae is a part of Fact Table.

Please help

Thanks
Tanweer



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.