Hi,

We have a requirement where the logic for a calculated member differs with
whether a particular dimension (Dim-A) is selected as a Row / Column
Dimension or selected as a filter.

I could not find out a way to identify whether a Dim-A is selected as
Row/Column dimension or as a filter in the MDX Expression.

I know there is an MDX function called “Axis” where Axis0 – is column &
Axis1 is Row. But I could not figure out the exact syntax.

Please help.
Prasad.

As you will see in the online book Axis function return a set
Convert this sert in a String with SetToStr function, then use InStr VB
function for asking if THE dimension is in this axis. Example:

InStr(1,"[MyDimension].", SetToStr(Axis(0)) )

if this expresion > 1 then columns are your axis.
And so on with the other axis.



"Prasad" wrote:

How do i use the VB function "InStr" in the Calculated Member Builder in MSAS?

Thx

"MartinDS" wrote:

In the Mdx Sample you will see the VB functions that can use in all the MDX
expresions.


"Prasad" wrote:

Hi Martin,

Thanks for your reply.

I was trying to build the calculated member using the MDX Expression
builder. Here are the 2 things i am trying to do and got the same error.

Unable to update the calculated member.
Formula error - no set holder when referencing a named <set>.

Sample 1:

InStr(1,"[MyDimension].", SetToStr(Axis(0)) )

Sample 2:

Iif(InStr(1,"[MyDimension].", SetToStr(Axis(0)) ) > 1, "True", "False")

Please help with the syntax,

Thx


"MartinDS" wrote: