Re: Multiselect dimension

Tech-Archive recommends: Fix windows errors by optimizing your registry

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6B493D16-DEF9-4BB4-82CF-966076D7BD9E@xxxxxxxxxxxxxxxx
how do i specify dimension with axis(1).count
in my example, dimension name is [country]


"Kalyan" 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:

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

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

"Kalyan" <Kalyan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:944A7574-EB78-4AD6-9AB7-1FFA497E571A@xxxxxxxxxxxxxxxx
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






.

Relevant Pages

  • RE: Calculating Max Usage with OLAP
    ... to answer your question about how to only build aggregations at ... dimension and then looking at the Advanced tab in the properties pane). ... The combined number of members on both these ... > Max Used Licenses means –how many concurrent licenses have been used during ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem with Member Counts and applying filters using MDX in M
    ... Now i am trying to count the "members" in this big dimension based on ... various possible filters that the user might apply. ... So far i am able to get the count of members on this big dimenion with one ... Here is the MDX i am trying.... ...
    (microsoft.public.sqlserver.olap)
  • Re: MDX Compatibility Property
    ... It looks like a bug. ... Please do not send email directly to this alias. ... The dimension browser forms an integral part of our ... have hidden members work ok! ...
    (microsoft.public.sqlserver.olap)
  • Re: Help Needed with Dynamic Dimension Security
    ... business application for securing members. ... and the point in the hierarchy where the security ... > of using Dimension Security with a Virtual Cube. ...
    (microsoft.public.sqlserver.olap)
  • RE: Computing histograms / bins in MDX
    ... you can't define a new dimension for the scope of a query unfortunately. ... if you have too many buckets to define manually and you don't mind ... //OF MEMBERS IN AS THE NUMBER OF BUCKETS DESIRED ...
    (microsoft.public.sqlserver.olap)