Hello friends,
I am new to DW/BI and MDX tools, so respond accordigly.
Along with other dimensions and measures, I also get unit price of an item
in the flat-file from another application.

Here is the example of my dimensions and measures:
Dimensions:
Product Group with 1 level as SKU
Produt Line with 1 level as SKU
Region with 1 level as Customers
Business Unit with no levels

Measures:
Units Sold
Sales Dollars (Units Sold * Unit Price @ point in time)
Avg Unit Price (Sales Dollars / Units Sold)
Current Unit Price (may not be same as Avg Unit Price, hence I get it in the
file)

* I have defined 'Avg Unit Price' as calculated measure and it works great.
* But I am not sure how I can handle 'Current Unit Price', because there is
no calculation involved. At the same time it gets aggregated, which I don't
it to.
* Another question is - 'How can I make sure that Unit Price is visible only
when I am at SKU level and for all other dimensions and its level below, it
is NULL?

NOTE: Do you think, I will have to use MDX scipts? If yes, what will be the
syntax?

Any help on this will be appreciated.

Thanks,
-Umesh

Use a calculated measure with an IIF statement which returns the value of
the measure if and only if the current level of the Product dimension is at
the SKU level. Set the originial measure as invisible so end-users only see
the calcualted measure.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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