Dimension attribute values not showing

View previous topic View next topic Go down

Dimension attribute values not showing

Post  waziz on Thu Aug 02, 2012 9:22 pm

Hi guys.

.

cube brower and excel are not displaying an attribute value where i think it should.

The fact table does have a fk value "48" to the sk of that dimension attribute value which is 48 ,so from a relational database perpspective things looks fine.

i was wondering what could be causing that, because it's showing other attribute values in that dimension , but for some reason not showing that one.

Thanks

waziz

Posts : 2
Join date : 2012-08-02

View user profile

Back to top Go down

Re: Dimension attribute values not showing

Post  waziz on Tue Aug 21, 2012 9:23 pm

After exploring the data in the fact table in the data source view of the cube, the statuskey (fk) value i'm looking for does not exist.


On the contray the the statuskey value does exist in the fact table in the relational data wearhouse.


I was wondering what could be wrong here? Is it the processing settings. i am in dev environment so i've been processing the database and the cube in Full mode, with no luck.

waziz

Posts : 2
Join date : 2012-08-02

View user profile

Back to top Go down

Re: Dimension attribute values not showing

Post  Mike Honey on Mon Aug 27, 2012 12:47 am

Hi waziz,

This is more a Microsoft Analysis Services technical question rather than general Data Warehouse/BI - you would've gotten a quicker response on the MSDN forum for SSAS.

Anyway, I'd be checking the Data Source definition in your SSAS project. Note this can vary by Configuration.

Good luck!
Mike
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: Dimension attribute values not showing

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum