Current Position:Home > Share  calculation  Not working in the report

Share  calculation  Not working in the report

Update:10-11Source: network consolidation
Advertisement
Iam surprised not to ge the simple share calculation not working at my report.
I have a dimension and corresponding values ( measures) .I made a Total at the end of the report. and I want to calcualte share of Total to each corresponding value.
how to do this, any thougts,...
I have used calculated memebers for this, But I wan to make the percentage of the total ( which is calculated inside Tool itself)
Please help....

The Best Answer

Advertisement
Prassad,
Not totally sure what you are trying to achieve but there a couple of possible solutions:
1) Total = total of all dimension members. Assuming you only have three dimension members then you should have a fourth member called ALL_DIMS or something similar. In the Share calculation template you need to specify the Total level as the basis for your share calc. This will generate the following result:
                         Revenue  % Share
- All Members     600         100%
     A                  100           17%
     B                  200           33%
     C                  300           50%2) The total you are referring to is in fact a sub total and is the result of adding together only the results for A + B + C, i.e. you have hundreds of dimension members but you specifically want to see a total for just these three members. To do this create a new custom aggregate call "My Total" and add together the dimension members A + B + C - Custom Aggs are a new feature to Discoverer OLAP (Checkout Mark Rittman's excellent blog article for more information on this feature: http://www.rittmanmead.com/2006/11/13/checking-out-the-new-discoverer-101220-features/)
Then in the Share calculation wizard set the basis for your index using the last option in the list "Specific Dimension Member" and select your new custom aggregate member.
Hope this helps
Keith Laker
Oracle EMEA Consulting
BI Blog: http://oraclebi.blogspot.com/
DM Blog: http://oracledmt.blogspot.com/
BI on Oracle: http://www.oracle.com/bi/
BI on OTN: http://www.oracle.com/technology/products/bi/
BI Samples: http://www.oracle.com/technology/products/bi/samples/
  • Share  calculation  Not working in the report Update:10-11

    Iam surprised not to ge the simple share calculation not working at my report. I have a dimension and corresponding values ( measures) .I made a Total at the end of the report. and I want to calcualte share of Total to each corresponding value. how t

  • Market Share calculation of many products and markets. Update:11-30

    Hi all, I would really appreciate if you can help me on the below business issue of Market Share Calculation. Prd_ID = Product ID PS  =  Product Sales M_ID = Market ID MS  = Market Sales MS%  = Market Share <b> Prd_ID;PS;M_ID;MS;MS%</b> A00001

  • Cross Tab calculation in Individual column-Crystal Report Update:10-11

    Hi experts I am preparing a report in Crystal report 2008. Report template is Cross Tab. Structure of report is Cardname-Row, DocType-Columnd, DocTotal-Summarize field. Result of this report is                       IN(Invoice)             RC(Incomin

  • Calculation of Results in BEx Report. Update:10-11

    I want to use weighted average method between two keyfigure. for example consider the following secnario.         CH Kf1 Kf2         A  10   5         B   6   4         C   3   2 <b>Result     19   4.21</b> how 4.21 is ((105)+(64)+(3*2))/total

  • Sum of calculated key figures in a report Update:11-30

    Hi, i have the following report : Country      percent FR                0% SP               100% GE               100% UK               100% I want to display at end a line with : sum percent / number of country The result should be : 300/4 = 75% bu

  • Column calculations getting wrong will exporting report to excel Update:11-30

    Hi Experts, we have a report on obiee 11.1.1.5.0 with following details we have report with columns destination region,service , origin country and revenue and report is created as follows Destination Region Asia NorthAmerica Total(using selection st

  • Calculating Average dynamically in BW Report Update:11-30

    Hello experts, I need to create a report where in I need to display month wise billing qty along with the average qty, here 'billing qty' is a key figure and "avgqty" should be calculated dynamically. The formula for avgqty is : "average qt

  • Residual order plan not calculated, in Object Currency for report 12KST1C Update:11-30

    Hello everybody, I have a question related to PS report painter Costs reports. I have created a form by copying the 12KST1C standard form, and I needed to create it, in order to change it and display the data (Costs, actual, commitment and so on) in

  • SORTING FOR THE CALCULATION FIELD IN CROSS TAB REPORT Update:11-30

    LIST_G_AUCTION_TITLE> <G_AUCTION_TITLE> <BID_NUMBER>5002</BID_NUMBER> <AUCTION_TITLE>E2E-01 Construction RFQ</AUCTION_TITLE> <ITEM_NUMBER>C2631</ITEM_NUMBER> <ITEM_DESCRIPTION>4G000,000,0STRUC,X,SPECIAL S

  • RRI - Sending  Dynamically calculated Variable Values to Receiving Report Update:11-30

    Hello, 1st report requires that user enters 2 dates. User exit is calculating the "number of months" between these 2 dates and the value is being stored in a variable. This calculated value "no of months" needs to be sent to the receiv