Formula error on created member

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top