Question about using format in MDX - for MDX experts

Discussion in 'microsoft.public.sqlserver.olap' started by Learner, Apr 11, 2004.

  1. Learner

    Learner Guest

    Hi,

    First, I know I have my basics wrong here so let me first give a
    background. Please ignore this stupid part :)

    1,000,000 = 100 Thousand. Right?
    10,000,000 = 1 Million. Right?
    100,000,000 = 1 Billion. Right?

    Please help me clear up my understanding if the above is wrong and again
    I know this is a very silly question. I know that the question below
    could have been phrased much clearer if my basic concept about the #'s
    was correct :( so please bear with me and guide me where you can...


    Now

    I want to use the format function in MDX in such a manner that if the
    maximum sales is 10 Thousand then the measure total should be shown in
    Thousands e.g. 0.5 T, 1.2 T, 3 T, and so on

    if the maximum sales is 1 Million then the measure total should be shown
    in Millions e.g. 0.12 M, 0,5 M, 4 M and so on


    Many thanks in advance for your help.
     
    Learner, Apr 11, 2004
    #1
    1. Advertisements

  2. Are you really sure you want this ?

    Sounds like you need different reports...one formatted in thousands, one in
    millions and so forth...

    If you make a sentence which automatically formats the numbers you would'nt
    know what youre looking at...would you ?

    About formatting the numbers you can use the #'s ... don't know which front
    end youre' using but in xp these can be used as well.

    And these codes can be used in Analysis Services. Examples:

    Thousand #,#00,
    Million #,##0,,
    etc...

    I'm not sure if you need to change these if you have a different language -
    dont think so.

    \Michael Vardinghus
     
    Michael Vardinghus, Apr 11, 2004
    #2
    1. Advertisements

  3. Learner

    Learner Guest

    Thanks for the reply.

    Two last questions please: If I use the "#,#00," for Thousands, can I
    use "#,#00, T" to indicate that the values are in thousands?


    Also how do I solve the part where I apply the formatting as per my
    question I.e.
    Suppose my MDX currently is as follows:
    iif(Current dimension.name=Open Time dimension.name,null,((Length
    measure,Open Time dimension.currentmember)-(Length
    measure,parallelperiod(year,1,Open Time dimension.currentmember)))
    /(Length measure,parallelperiod(year,1,Open Time
    dimension.currentmember))*100)


    Sorry for the botheration.

    Regards.
     
    Learner, Apr 12, 2004
    #3
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.