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

SSAS Pivot refresh Expand / Collapse
Author
Message
Posted Friday, July 18, 2014 5:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 15, 2014 11:47 AM
Points: 50, Visits: 222
Hi All,

Request your help in the below scenario which i came across today.

I had a pivot to pull data from cube previously.The pivot had certain measures which are now set as invisible measures at the cube level itself.

After the cube publish,i just reconnected my pivot to the cube so that the new measures and dimensions are shown in the field list.

I just tried refreshing the pivot with my old measures(which are now set as invisible) and it allowed me to refresh.

How can this be possible if the measure itself is set as invisible at cube level?

Request your inputs
Post #1594269
Posted Wednesday, July 23, 2014 9:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 10, 2014 5:37 AM
Points: 434, Visits: 1,324
It is because invisible measures can still be used, if the measure name is known.
Post #1595540
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse