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
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: Wednesday, February 25, 2015 1:16 PM
Points: 51, Visits: 232
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


Group: General Forum Members
Last Login: Tuesday, February 24, 2015 2:10 AM
Points: 495, Visits: 1,352
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