Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

same measure in 2 cubes, but not displaying data in one cube related reports only Expand / Collapse
Author
Message
Posted Thursday, January 10, 2013 9:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 8:11 AM
Points: 78, Visits: 233
Hi , I have a measure called "Stock Sales COGS Local Currency" in sales cube and monthly cube.
product levels are 6 in my product hierarchy. like HC4, HC3,HC2,HC1,HC0, Product.

for "50026789" product and "Stock Sales COGS Local Currency" am getting data in sales cube reports but not in monthly cube report.

Measure coming from same fact table in 2 cubes.
can anybody please let me know the clue of this issue.

Thanks,
Niha
Post #1405750
Posted Tuesday, January 15, 2013 4:30 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 11:49 AM
Points: 43, Visits: 319
I'd try the dimension relationships. Make sure that measure group and dimensions have relationship in the dimension usage page.

~Sam.

http://svangasql.wordpress.com
Post #1407159
Posted Tuesday, January 15, 2013 4:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
Three palces you need to check :-

Dimension mapping
Perspective
Permissions on the measure group.


Jayanth Kurup
Post #1407161
Posted Tuesday, January 15, 2013 9:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 8:11 AM
Points: 78, Visits: 233
Thanks Sam for your reply, relations are in place.

problem is for only one product it is not showing data.





br,
Niha

Post #1407332
Posted Tuesday, January 15, 2013 9:31 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 8:11 AM
Points: 78, Visits: 233

HI Jayanth, thanks for your reply.

can you please elaborate on these 3, what need to be checked or what can be changed.

Dimension mapping
Perspective
Permissions on the measure group.

Thanks again,
Niha
Post #1407334
Posted Wednesday, January 16, 2013 1:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
niha.736 (1/15/2013)

HI Jayanth, thanks for your reply.

can you please elaborate on these 3, what need to be checked or what can be changed.

Dimension mapping
Perspective
Permissions on the measure group.

Thanks again,
Niha


Dimension mapping = dimension usage tab. Make sure all the relations between dimensions and fact tables are set correctly.
Perspectives: check if you are using a perspective or not and if yes, if the measure is enabled in the perspective.
Permissions: this is self-explanatory. Check if there is security set on the measure data and if the user you are currently using has the rights to view the data.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1407654
Posted Wednesday, January 16, 2013 10:29 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 8:11 AM
Points: 78, Visits: 233
Thanks Koen for your explanation,

yes, I checked thoroughly according to your explanation.

1. Mappings are absolutely fine
2. It is not perspective, I browsed direct cube only.
3. I can see all the data from that Fact table to all product levels( except one product)


Is there any other chances causing this?

Thanks alot,
Niha
Post #1408144
Posted Thursday, January 17, 2013 2:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
if the issue is only for the single product make sure the data is present in the underlying database and the cubes have been processed.

Jayanth Kurup
Post #1408251
Posted Friday, January 18, 2013 12:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
Jayanth_Kurup (1/17/2013)
if the issue is only for the single product make sure the data is present in the underlying database and the cubes have been processed.


Also make sure there isn't something in the data source view filtering data out.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1408731
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse