Default Report Templates ex: Trend

[Former Member]

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.

[SEdelstein · Accepted solution]

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

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

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.

[SEdelstein]

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

[Former Member]

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.

[Former Member]

Sorry, instead of giving EVGTS() fucntion, i mentioend EVSND().

Do i need to give EVGTS() function for Report Templates???

Thanks,

Ben.

[Former Member]

Hi Nagesh,

These dynamic templates use EVDRE function and thus no need to use EVGTS function. EVDRE replaces the need of evgts and is much better in terms of performance.