Cube browser allow user to multiselect in a dimension, Is there anyway to
count how many dimension's value user selected. I am using AS2000.

for example

I have country dimension

Country

USA
Canada
Mexico
England
Spain
France
Italy
India
Singapore
Malayasia
....
....


In the above dimesnion,
If user select

Selection Result

USA,Canada,Mexico 3
England,Italy 2
India 1
India,Singapore 2

Any help

Thanks
Kalyan

use the axis function
axis(0) returns columns
axis(1) returns rows

so axis(1).count should return the number of members.

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

Thanks JeJe, I want to create calculated member, how do i use axis function
in calculated member, can you give example.

Yesterday I asked about cube processing, I created noncluster index on all
the dimension columns, now it is taking about 10 min, Is this correct method,
I tried sp_updatestats and defrag index, finally i created index on dimension
column that solved. Thanks for giving startup to think.

Waiting for your reply

thanks
kalyan
"Jeje" wrote:

how do i specify dimension with axis(1).count
in my example, dimension name is [country]


"Kalyan" wrote:

axis(1) return the row set.
This can include multiple dimensions & members.

to count 1 particular dimension only in this set:
extract(axis(1), <Dimension to extract>).Count

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

I entered formula like this in calculated member box
Cost Division is my dimension name

extract(axis(1), [Cost Division]).Count

Getting error msg.


Unable to update calculated member

Formula - no set holder - when referencing a named <set>

why i am getting this error

Thanks
Kalyan




"Jéjé" wrote:

try:
extract(axis(1), [Cost Division].[my hierarchy]).Count
or
extract(axis(1), [Cost Division].[attribute name]).Count

these formulas can produce errors if the user has nothing in rows or if the
Cost Division dimension is not used in the MDX source query.

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

JeJe

Thanks for reply. I am new to mdx query,
how to i get attribute name. I created dimension through wizard, No where it
asked attibute, can u tell me how to get attibute name or define to a
dimension.



"Jéjé" wrote:

hi

I tried like this

extract(axis(1), [Cost Division].(all)).Count

Still getting same error msg. please help me





"Kalyan" wrote:

to access an attribute:
<dimension>.<attribute>

to access a user defined hierarchy:
<dimension>.<hierarchy name>

I don't kown what are your attributes and user hierarchy in the cost
division dimension.
but you have to use something like:
extract(axis(1), [Cost Division].[<cost division leaf level
attribute>]).Count

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote