Re: Multiselect dimension

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FCEC313D-4FF9-4C13-BF47-EB86D7B8B27A@xxxxxxxxxxxxxxxx
hi

I tried like this

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

Still getting same error msg. please help me





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

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

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9B9E4A74-2AED-4E02-A439-1DEEAA22D1F5@xxxxxxxxxxxxxxxx
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:

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: Dimension 8200 Tower case
    ... The systems I bought from Dell or Overstock.com came with Windows ... Maybe sell the 8200 to help offset the cost. ... The motherboard from a Dimension 8300 or 8400 would likely work. ...
    (alt.sys.pc-clone.dell)
  • Re: Counter example for Mr. Diaby algorithm solving TSP problem in polynomial time
    ... In my paper I show idea: how you can "beat" first dimension of variables, ... every equation correct then it is compliant with your model... ... Or solve instance of 32 nodes with cost function described by algorithm ... nodes - within valley cost is always 1 between valleys it is 1000): ...
    (comp.theory)
  • Re: The economics of Harry Potter
    ... Magic has a cost, it requires effort by magicians or spirits. ... Where does the extra energy come from? ... It could come from another dimension. ... For science fiction about conservation of energy and alternate ...
    (rec.arts.sf.written)
  • allowed member set MDX expression
    ... I'm trying to implement dynamic dimension security in a SSAS 2005 ... I have the "Cost Object" dimension consisting of two hierarchies: ... Cost Object Hierarchy ...
    (microsoft.public.sqlserver.olap)
  • Blank pivot when displaying a dimension member and a calculated member.
    ... And I have a calculated member called "TOTAL COST" created from ... this dimension which is. ... When I show the pivot, I have a case, where REVENUE is zero and COST ...
    (microsoft.public.office.developer.web.components)