Hello Everyone
I have a Point Chart based on a OLAP. I would like to show the probability that how many deals will close in the next 30 days.
Is there a calculation that I need to apply or filter? Do you know what that calculation will be.
I have a Opportunity Amount as a measure, Probability as a Dimension and series as a State.
I will greatly appreciate your help.
I think we would need a little more information than that. Is the Probability that you've got at the moment the probability that any given opportunity will close? If it is then I would imagine that you'd be interested in the (Probability * Number of Opportunities)
Yes, that is correct.
For each client, there is a probability based on 7 different stages. Attach please find a sample spreadsheet to better understand.
Thanks
OK - I'm still not clear what you're trying to get to. Based on your data, are you expecting a value of 3.05? That's "expected" number of opportunities that will be won. Or are you looking for 4,915.5 which is the sum(probability * amount). If you can define what you're trying to get to, we can help you get there.
I think I was making it over complicated. Can someone please tell me how to add a filter to get record to for the next 90 days.
Its an olap cube.
here is what I am using and it is error out:
intersect(lastPeriods(-9999, #'[myCube].[fiscal Date].[fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask($current_timestamp,'yyyymmdd') +']'#), lastPeriods(9999, #'[mycube].[fiscal Date].[Fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask(_add_days($current_timestamp,90),'yyyymmdd') +']'#))
Thanks in advance :) :) :)
Quote from: CognosDev007 on 03 Nov 2014 09:38:23 AM
I think I was making it over complicated. Can someone please tell me how to add a filter to get record to for the next 90 days.
Its an olap cube.
here is what I am using and it is error out:
intersect(lastPeriods(-9999, #'[myCube].[fiscal Date].[fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask($current_timestamp,'yyyymmdd') +']'#), lastPeriods(9999, #'[mycube].[fiscal Date].[Fiscal Date].[Day]->:[PC].[@MEMBER].['+ timestampMask(_add_days($current_timestamp,90),'yyyymmdd') +']'#))
Thanks in advance :) :) :)
How about:
lastPeriods(91, #'[myCube].[fiscal Date].[fiscal Date].[Day]->:[PC].[@MEMBER].[' + timestampMask(_add_days($current_timestamp, 90),'yyyymmdd') + ']'#)
As I mentioned before, you should not use detail filters with dimensional sources. This would either be a query calculation in your report to display the members, or it would be a slicer member set in a slicer filter in your query (depending whether you want to see the members or just change the context of the measures for these members).
MF.