R
roger.camargo
I've created a member on the cube:
CREATE MEMBER [MyCube].[Measures].[NewMeasure] AS 'StrToSet("Axis
(0)").Count'
When I add a dimension to the pivot table rows the table is like this:
Currency NewMeasure
Dollar 3
Euro 3
Grand Total 3
But when I add another dimension (Bank) to the same axis I get an
error:
Bank Currency NewMeasure
The query could not be processed:
o Formula error - no set holder - when
referencing a named <set>
I'm trying to work on Calculated members and trying to use StrToSet
("Axis(0)") to do a calculation based on the visible members on the
axis of the pivot table, but this error is stopping me to go on, and
this only happens on OWC, this works on Excel 2003, Excel 2007,
Proclarity. Is this a known bug? Known issue? Are there any
workarounds?
Other functions that didn't work on my calculated measure:
StrToSet("Axis(0)").Item(0).Count
StrToSet("Axis(0)"),Item(0),Item(0).Count
Note that this: StrToSet("Axis(0)"), is needed for visual rankings,
visual percentage participations, if this doesn't work, I'm afraid
that I'm not gonna be able to use visual rankings, and other stuff,
please help me.
CREATE MEMBER [MyCube].[Measures].[NewMeasure] AS 'StrToSet("Axis
(0)").Count'
When I add a dimension to the pivot table rows the table is like this:
Currency NewMeasure
Dollar 3
Euro 3
Grand Total 3
But when I add another dimension (Bank) to the same axis I get an
error:
Bank Currency NewMeasure
The query could not be processed:
o Formula error - no set holder - when
referencing a named <set>
I'm trying to work on Calculated members and trying to use StrToSet
("Axis(0)") to do a calculation based on the visible members on the
axis of the pivot table, but this error is stopping me to go on, and
this only happens on OWC, this works on Excel 2003, Excel 2007,
Proclarity. Is this a known bug? Known issue? Are there any
workarounds?
Other functions that didn't work on my calculated measure:
StrToSet("Axis(0)").Item(0).Count
StrToSet("Axis(0)"),Item(0),Item(0).Count
Note that this: StrToSet("Axis(0)"), is needed for visual rankings,
visual percentage participations, if this doesn't work, I'm afraid
that I'm not gonna be able to use visual rankings, and other stuff,
please help me.