on 05-24-2010 9:24 PM
Hi,
I have quick question of default or SAP given report Templates. How to use these templates? Assume based on my current view i have 10 accounts in rows and 4 measures in Columns (1st quarter). it is going to be around 40 cells in my report to display data.
do i need to use EvSnd() statement in all the 40 cells? If i refresh my query these 40 cells getting refreshed. Every time i need to enter 40 cells in my report. I know i was not doing right. Can any one guide me to display all the cells after refresh the work books as well.
How to dynamically populate the cell definition for all cells imean to say if i use 2006.TOTAL for measure which will give me 130 cells. how to dynamically pass the EVSND() function?
Appreciated all your help!!!
Thanks,
Ben.
HI Ben -
You an use the delivered templates as suggested, but you have a few more easy to implement possibilities to consider:
1. You can use drag-n-drop to create a report/schedule. The Drag-n-Drop will be based on EVDRE functionality so you do not have to be too familiar with how to set up EVDRE to use it.
2. You can create you own report.schedule and base it upon EVDRE functionality starting from a blank worksheet.
3. You can use the EVDRE wizard (EVDRE Builder) to help create your custom report/schedule.
Please view the Help guide for this and other reporting options at:
[http://help.sap.com/saphelp_bpc75_nw/helpdata/en/56/5a2813c565475a8d8ed087c750ee96/content.htm|http://help.sap.com/saphelp_bpc75_nw/helpdata/en/56/5a2813c565475a8d8ed087c750ee96/content.htm]
Regards,
Sheldon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if i execute SAP given templates reports in Excel for given Current view, i never got any data without using EVGTS() function. Am i missing some thing?
Till now i thought i need to use EVGTS() function in SAP given template or EVDRE() function based report .
If i use EVGTS(), i'm getting data. Can any os you help to create a report wihtout using EVGTS() function in SAP report or my report using EVDRE() function.
Appreciated all your help!!!
Thanks,
Ben.
Hi,
In BPC NW, the dynamic templates are built using EVDRE function and doesnt require EVGTS function. Please confirm that you are using the NW version and you are opening the dynamic templates.
Alternatively, when you try to create any template, you can try to use the EVDRE functionality.
Hope this helps.
Hi Ben -
More that likely your inability to see data using EVDRE is probably due to your expansion settings. Please review the help file on setting up your Member Set Expansion properties at:
[http://help.sap.com/saphelp_bpc75_nw/helpdata/en/13/a6464673df4c97b49a9cb5f62c82ce/content.htm|http://help.sap.com/saphelp_bpc75_nw/helpdata/en/13/a6464673df4c97b49a9cb5f62c82ce/content.htm]
Regards,
Sheldon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In the dynamic templates provided by SAP, if you use input schedule, you dont have to use evsnd function. The data will be sent automatically from the template by clicking send data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.