cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW : Issue with Excel based Planning application having SAVE button

Former Member
0 Kudos

Hello Experts,

I am looking for urgent help on 3 issues that we are facing on SAP BW: excel based planning application created for Planners. They will analyze stock and demand of a material and then select comments from 3 dropdowns and then save it.

Issue #1. We have created workbook having two tabs
"DataDump"and "Input Ready" Report. As the name indicates, the Save functionality is available on the Input Ready tab of the workbook. After saving here, the dataDump tab will be automatically refreshed with the updates. On the Input ready tab, a white line at the end of the report indicates that the report is available for editing comments. For few userIds, this white line is not displayed. Can you please let me know if there are any system settings/user settings required to execute Input Ready queries.

Issue 2: The heading of Datadump tabe is "DataDump Report"

The heading of Input ready report is "Input Ready Report".

For few user Ids, the heading of Input ready report displays "Data Dump Report"

Issue#3: How can we allow concurrent edits in the workbook?

currently, If one planner has opened workbook for a particular Plant having 100 materials, then all other planners are blocked from entering comments for any of the materials in that plant. other planners can only view the data for that plant.

Is there a way to display popup message on which userIds have currently logged in to the workbook?.

It would be really helpful if you help me solve the issues

Thanks in Advance

Accepted Solutions (0)

Answers (1)

Answers (1)

cornelia_lezoch
Active Contributor
0 Kudos

Hello Tanu,

please specify your question more in detail.

Which Excel Forntend Tool are you using - Bex? AfO? Something else?

When you write, that users shall change comments - do you really mean comments or plan data?

Because you write "

a white line at the end of the report indicates that the report is available for editing comments. For few userIds, this white line is not displayed. Can you please let me know if there are any system settings/user settings required to execute Input Ready queries.

" which does not really make sense - it´s either the comment functionality thats missing or the input ready query for plan data ...

Either way - if it does not work for certain users, check the authorizations

then for your last question about "concurrent users in the same workbook" - this is nonsense, the workbook itself can be opened as often as you want, each users gets his/her own "application" = single workbook. BUT the DATA can be changed only by one user in one application. So check the lock characteristics and the selections in the query.

regards

Cornelia

Former Member
0 Kudos

Hello Cornelia,

we are using Bex (BI AddOn 7.x) based on 7.3, Support Package 0 and Revision 1829. We have provided 3 dropdowns in each record. So, user need to select the comments from these dropdowns and then Save