Click here to monitor SSC
SQLServerCentral is supported by Redgate
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


Group: General Forum Members
Last Login: Tuesday, September 20, 2016 9:35 AM
Points: 100, Visits: 303
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, September 26, 2016 7:18 AM
Points: 527, Visits: 1,436
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