-
Simple Question using Avg Function
I have a cube with 8 dimensions: time, organization, customer, item, region, market, salesperson, shipped_from
3 Measures: invoice_qty, invoice_price, sales_total
I want to get the average invoice_price for an item ...across any dimension or groups of dimensions... what is the proper syntax for creating a calculated member using the dims and measures above
Thanks in advance
Steve
-
The good news is that this has been covered in detail at:
http://databasejournal.com/features/...le.php/3404601
Please get back with specific questions after you give it a quick read. And if you intend upon writing MDX with any regularity, please review the series on occasion. I expect to be here for a while ...
Good Luck,
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|