May 18, 2006 at 11:17 am
My Issue Example:
Dimensions=OrderAgent, TransactionDate, TotalCalls, OrderCount, OrderTotal, CancelledCount, CancelledTotal
Within Web Pivot Table Query:
FILTER=TransactionDate
COLUMN=TotalCalls, OrderCount, OrderTotal, CancelledCount, CancelledTotal
ROW=OrderAgent
What I want to do is create, within the query (NOT within Cube Editor) 2, additional columns. One for Conversion Rate, where Conversion=OrderCount/TotalCalls as a percentage AND one for Cancel Rate, wher Rate=CancelledCount/OrderCount (percentage)
I see how to create a new column with an expression, however, I want to reference specific column values within this calculation.
So far, I'm only seeing info about how to do this in Cube Editor--but I want my end users to be able to create their own Cube Reports with this kind of functionality...I don't want to have to process the entire cube every time.
Any help much appreciated!
May 19, 2006 at 7:44 am
Sarah,
If the data source for your Web Pivot Table is OLAP, your users will not be able to use the "Create Calculated Detail Field" option on the Pivot Table toolbar. It sounds like this is the functionality you are looking for.
See
http://office.microsoft.com/en-us/assistance/HP052389601033.aspx
May 20, 2006 at 7:14 am
You could try the Excel Add In/Acellerator for OLAP (search MSDN using those terms). It will elt your users use the OLAP data in Excel in quite free form ways.
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply