Question:
Hi
This is in connection with SEM CPM
I am designing the management cockpit for top 10 cutomers based on sales. I've to bring in the current quarter sales and previous year-current quarter sales.
I 've developed a query which brings top 10 customers for current quarter and previous year current quarter.
While i am designing the frame in cockpit, i am not able to get the top 10 customers from the query instead, i am getting value bearing characterics for customers. It is giving for all customers. I feel, it is reading all the data not based on top 10 query. I need to bring in only 10 customers into my frame.Doesany one know where i 'm wrong ...in designing the graphics or something to do with buffer.
Appreciate your help
kvr
Answer:
Kvr,
How r u reporting? if you r reporting using standard Bex queries, then i guess the problem is with the buffer.It must have been set to a high percentage.....
So if you answered my question as yes, then go to RSRT and type the technical name of your query and click on properties and set the query not to have any kind of buffer.Buffer helps mainly for queries with large result set, and in my opinion is not suitable for SEM applications as SEM doesnt deal with large volumes of data like BW does.
Also check how you have designed your query ? does it have any kind of conditions?
hope this helps and read the OSS note on CPM performance which i had earlier suggested.
Vamsh
Answer:
hi kvr,
i faced the same prob in one of my implementations.
do one thing -
write another query based on this query to display the top 10 customers and assign the second query to ur cockpit.
i don't think the rob lies in buffer or going thru RSRT will work. if it works do let me also know.
andy.
Answer:
hi kvr,
i faced the same prob in one of my implementations.
do one thing -
write another query based on this query to display the top 10 customers and assign the second query to ur cockpit.
i don't think the rob lies in buffer or going thru RSRT will work. if it works do let me also know.
andy.
Very true
Anand u had explained these earlier
only diff is then u were cpm guru now u r cpm friend
/forums/viewtopic.php?t=141096&highlight=
Hope it Helps
_________________
Chetan
@ CP...
Answer:
chetan c a similar post, then u were the bw guru and now u r the sem guru.
http://sapfans.com/forums/viewtopic.php?t=147285&sid=9e23ff30cfbff1d187be3d2b836cf29a
V
Answer:
cpm_friend
I have created another query similar to that and included in cockpit. During selection criteria, I have mentioned 'all customers name ' for characteristics on value bearing characteristics tab.AT data preview stage, it is giving me all customers which even query doesnt bring.still, its doing the same....
Vamsh,
I have conditions in my query which brings top 10 customers. How does it effects in CPM.I have given the option read from buffer in my cockpit. I went to rsrt and mentioned chache inactive and 0 query will be optimized before generation. Is this what i need to check in RSRT for switching off buffer or to low percentag.I did that
If this is causing due to conditions in Query, what needs to be done. One quetion i have is, if i choose all customers name in selction criteria(value bearing master data for customer) in my frame I'm seeing all customers and not only those customers in my query.
any thoughts...
Appreciate your help
Veeru
Answer:
Veeru,
Ignore the conditions part in the query that may or may not help, but do this.
when you go to RSRT, type the name of your query,and then on the left hand corner choose, Query>Properties and then a pop box will appear , where you in the drop down box for cache choose 0, which is no cache.
Set the query results with no cache.
hope this helps. Update the forum.
V
Answer:
Hi Vamsh,
I set the cache to 0 and query optimization mode to '0 query will be optimized after generation'. Is this the query result you are talking abt. I set up this one in RSRT and went to cockpit design and set READ FROM BW instead of READ FROM buffer also. The graph is displaying all customers still.. The query brings only 10 customers and havent removed condition. I appreciate your suggestions
Any thoughts..
Veeru
Answer:
Veeru,
Read these OSS Notes 598495,437466, check if this helps you in anyway?
let me know , i know some more OSS notes which could guide you more.
Vamsh
Answer:
i have read those sap notes .uhmm, mite not be usefull.Now , let me clarify you guys abt my requirement.
My Characteristics and KF in my query are
1)Customers---Rows
2)Sales for current quarter
3) sales for previous quarter
Two BW text variables are used to bring the data
1) Current Quarter
2) Last Year Current Quarter
One condition is used to bring only top 10 customers
Now in my frame , i need the following graph
The user enters the current quarter and last year current quarter and the graph should show sales of current quarter as well as last years current quarter for top 10 customers which the query will bring. The Top 10 cutomers are not fixed . They change based on the quarter.
So my X axis (section axis} in my bar chart is Customers. My data series are the two KF's. My question is how can i make my section axis to bring top 10 customers based on the current quarter. I cannot fix the 10 char values for customers in my selection criteria as the top 10 customers change based on current quarter the user enters.
can this be done by creating CPM variables or time variables for characteristic Customer. If so, whats the logic . am i confusing you too much.... I'll explore more about cpm variables ..Any suggestions are highly appreciated..
thanks
Veeru
Answer:
KVR,
You will never be able to have top customers selection in Managment Cockpit even though you attach a query with top 10 selection.
The reason being Managment Cockpit will read all the number and will not recognize the selection criteria applied in query.
We had discussed this problem with SAP during one our implementation and the answer was the limitation of product.
Regards,
Maheshvk
_________________
Mahesh Karambelkar
Answer:
KVR,
You will never be able to have top customers selection in Managment Cockpit even though you attach a query with top 10 selection.
The reason being Managment Cockpit will read all the number and will not recognize the selection criteria applied in query.
We had discussed this problem with SAP during one our implementation and the answer was the limitation of product.
Regards,
Maheshvk
Welcome to the Forum Mahesh,Hope u doin good in Philadelphia.
Incidentally i was on same Project with u
Solution for these was given earlier on these forum of attaching other query....by andy
Example
suppose you have a query A on which you want to find top 5 (u can see top 5 in BW, but not in cockpit, right?) write a query B which takes input of top 5 from query A and attach the query B to cockpit
Hope it Helps
_________________
Chetan
@ CP...
Answer:
How can i read input from one query and write a second query.
Could you elaborate how i can acheive this.
I appreciate all your suggestions and ideas .
Thanks
veeru
Answer:
How can i read input from one query and write a second query.
Could you elaborate how i can acheive this.
I appreciate all your suggestions and ideas .
Thanks
veeru
In short-
RRI-Report to Report interface ,with 2 queries interlinked.
First query as an input to the second query.
Plz read details of RRI on Help.sap.com
Hope it Helps
_________________
Chetan
@ CP...
Answer:
Hi All
Mahesh and chetan I was also there in the same project and spent two day to get top 5 ..
_________________
Sanju