I have a cube, we are using Panaroma cube browser, Where user can select
multiple value for a dimension, Example in calendar, they can select 2006
and 2005 same time,
I want to know in calculated member, how many dimension values selected.

Example :

Calendar

2002,2003,2004,2005,2006,2007.....


If user select 2002,2003 and 2004, Expected result in Calculated member is 3
If user select 2005,2006 , Expected result in Calculated member is 2

Any help please.

thanks in advance

kalyan

try a formula like:
extract(axis(0), "Timedimension").count


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

Thanks for reply,

I tried like this

extract(axis(0), "Calendar").count

Calendar is my dimension name, it raises error msg. syntax error, i am new
to AS2000, I checked syntax for Extract it says

Extract(«Set», «Dimension»[, «Dimension»...])

Can u update me, what exact meaning to <<set>>,

why my statement raises error, Can u help me where i am making mistake, please

Thanks
Kalyan





"Jéjé" wrote:

first,
the axis function return the set from the 0 = columns; 1 = rows; 2= filter
axis.

extract(axis(0), [Calendar]).count
(without quotes)

this raise an error if the [Calendar] dimension is NOT used in the axis 0
(which is columns)
AXIS(YY) raise an error if there is nothing in the axis YY
(so Axis(1) raise an error if the user has nothing in rows, Axis(2) raise an
error if there is nothing in filters...)


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

Thanks for reply, still i am getting error msg.

following is the error msg. i got
Unable to update the calculated member,
Formula error - no set holder - when referencing a named <set>


I want to know how many dimension value selected in dimension, i am using
this value in calculated member, if they select 1 only value i will do one
sum , if it is multple selection then i have another sum todo,

I am using AS2000.

Please reply me, waiting for your reply

"Jéjé" wrote:

can you post you calculated member formula?

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

Thanks for reply, Here is my situation,

I have 12 dimension, and about 8 measure. One measure is MILES,
I want a column where that display miles for the selected calendar dimension.

Example.
Yr. Miles

2002 4500
2003 5000
2005 5300
2005 5500
2006 6000

If user select 2002 and 2003 i want to display 9500, same time even if
they select or change other dimension value, mile should n't be changed.
Miles will change only if user changes calendar dimension. This will help
them to draw graph for any given dimension agaist total miles for that period.


Thanks
Kalyan



"Kalyan" wrote:

use the visual total function
or the aggregate function to do the sum.

can you send the complete MDX query you use?
what is your access tool?

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

Hi Jéjé

What i am using in calculated member is

SUm([Calendar].CurrentMember.level.members, [Measures].[smiles])

Whenever user changes calendar, i am getting miles for that period, that's
fine. but CATCH is, I have another dimension costcenter if user changes
costdivision for that costdivision, i am getting miles, that's the way it
should work. but my requirement is miles should change when calendar changes
otherwise it should remail same for that period for what ever dimension
changes

example

Year Cost division Miles
2005 V 120
2005 RM 280
2005 RX 100

Total Miles for 2005 = 120+280+100 = 500

Even user select costdivision V, it should n't display 120, i want to force
cube to display total miles. this will be usefull for them to draw graph
agaist total miles with other dimensions.

I hope u understand my situation, Hope to give good soultion for me to get
out of this situation.

thanks
kalyan




"Jéjé" wrote:

do you use AS2005?
what is your client access tool?
do you write an MDX query yourself? or does the client tool generate the MDX
for you?

in AS2005 you can create a scope and change the value of your measure in
this scope.
(like changing the calculation when you are at the year level)

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