Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Business Intelligence » same measure in 2 cubes, but not displaying...
Add to briefcase

same measure in 2 cubes, but not displaying data in one cube related reports only Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
niha.736
Posted Thursday, January 10, 2013 9:28 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:15 AM
Points: 68, Visits: 205
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
Sam Vanga
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, May 01, 2013 11:47 AM
Points: 39, Visits: 264
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
Jayanth_Kurup
Posted Tuesday, January 15, 2013 4:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008
Three palces you need to check :-

Dimension mapping
Perspective
Permissions on the measure group.

Jayanth Kurup
Post #1407161
niha.736
Posted Tuesday, January 15, 2013 9:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:15 AM
Points: 68, Visits: 205
Thanks Sam for your reply, relations are in place.

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





br,
Niha
Post #1407332
niha.736
Posted Tuesday, January 15, 2013 9:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:15 AM
Points: 68, Visits: 205

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
Koen Verbeeck
Posted Wednesday, January 16, 2013 1:13 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364, Visits: 6,462
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
niha.736
Posted Wednesday, January 16, 2013 10:29 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:15 AM
Points: 68, Visits: 205
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
Jayanth_Kurup
Posted Thursday, January 17, 2013 2:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008
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
Koen Verbeeck
Posted Friday, January 18, 2013 12:19 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364, Visits: 6,462
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.