cancel
Showing results for 
Search instead for 
Did you mean: 

How to load all records in input schedule in SAP BPC 7.5?

former_member189599
Participant
0 Kudos

Hi gurues!

I started to work in sap bpc 7.5 recently.

The client has an issue.

Last year, in the budget load, when they collected the input schedules that had been distributed, the system only loaded the cells that had been modified. So, the cells that had not been modified, weren' t loaded. This wasn't correct. They wanted all  the cells  to be loaded.

I know that this is the standard behavior of the system, but this year, their requirement is that the input schedule loads all data. This should include the modified cells and those that are not modified.

Thanks in advance!

Regards,

LUCAS

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186338
Active Contributor
0 Kudos

Hi Lucas,

In BPC 7.5 it's easy:

1. Using VBA editor unhide cash sheet (change from VeryHidden to Visible)

2. Look on the contents - the values on this sheet will be compared with values on the EVDRE input schedule... If there is a difference - the value will be send to BPC.

If you correct the cash sheet with some simple VBA code all values will be send!

But it's definitely something wrong with the requirements! Sending all data is very slow!!!

Vadim

former_member186338
Active Contributor
0 Kudos

Some pictures:

EVDRE_DATACACHE - very hidden!

Change to visible:

Result:

Concatenated text will be:

<EVDRE_CACHE><EVDRE ID="Sheet1|001-00001"><CELL>2012.APR|2020202020701| - 363000.0000000</CELL><CELL>2012.APR|2020202020704| - 15019446.9600000</CELL><CELL>2012.AUG|2020202020701| - 181500.0000000</CELL><CELL>2012.AUG|2020202020704| - 15582703.3500000</CELL><CELL>2012.DEC|2020202020704| - 6899071.5100000</CELL><CELL>2012.FEB|2020202020701| - 349500.0000000</CELL><CELL>2012.FEB|2020202020704| - 18687712.5900000</CELL><CELL>2012.JAN|2020202020701| - 589000.0000000</CELL><CELL>2012.JAN|2020202020704| - 15832504.2400000</CELL><CELL>2012.JUL|2020202020701| - 168000.0000000</CELL><CELL>2012.JUL|2020202020704| - 7699825.1100000</CELL><CELL>2012.JUN|2020202020701| - 181500.0000000</CELL><CELL>2012.JUN|2020202020704| - 13117368.1700000</CELL><CELL>2012.MAR|2020202020701| - 349500.0000000</CELL><CELL>2012.MAR|2020202020704| - 20051471.4900000</CELL><CELL>2012.MAY|2020202020701| - 712500.0000000</CELL><CELL>2012.MAY|2020202020704| - 14598479.7100000</CELL><CELL>2012.NOV|2020202020704| - 20762463.4700000</CELL><CELL>2012.OCT|2020202020701| - 459508.4700000</CELL><CELL>2012.OCT|2020202020704| - 18304847.1600000</CELL><CELL>2012.SEP|2020202020701| - 50000.0000000</CELL><CELL>2012.SEP|2020202020704| - 20727881.4400000</CELL></EVDRE></EVDRE_CACHE>

Vadim

former_member189599
Participant
0 Kudos

Hi Vadim!

Thanks for your answer.

The second point:


2. Look on the contents - the values on this sheet will be compared with values on the EVDRE input schedule... If there is a difference - the value will be send to BPC

My doubt it is, how can i send the records than has not been modified? This records must have the same value.

In the VBA Code, When I compare the values in both sheets (EVDRE_CACHE and USER_REPORT, if they are equals, then i should pass the value from EVDRE_CACHE sheet to USER_REPORT?

Thanks in advance!

Regards,

LUCAS

former_member186338
Active Contributor
0 Kudos

It's BPC engine doing compare of cache and EVDRE figures when user press Send and Refresh button:

1. If value is different, then EVDRE value is sent

2. If cache value is missing, then EVDRE value is sent

You can play with cache using VBA...

But please, explain the business requirements!

What is the reason to send all data???

If you have a wrong cache - you have to use another approach (also VBA)!!!

Vadim

former_member189599
Participant
0 Kudos

Thanks Vadim.

I hope I can explain the context.

The client want the input schedule to be load as the user send it. So, the user is the responsable for the data integrity and the Budget area only must collect the input schedule.

thanks, one more time.

LUCAS    

former_member186338
Active Contributor
0 Kudos

Hi Lucas,

It's not the right way of doing things, it's like creating you own BPC

There is an administrative procedure to fill and collect data with BPC:

1. Finance planning department prepare some starting figures in the current budget version (copy from previous or other methods).

2. Finance planning department prepare the budgeting template for the current budget version.

3. The template is copied, refreshed and locked using BPC distribution.

4. No changes are allowed in the BPC cubes after distribution (may be work status lock)

5. Users fill in locked templates without BPC connection.

6. Templates are collected and finance planning department will upload data from templates (changing work status to allow save).

NO ISSUES WITH CACHE!

We are using this procedure for years...

Vadim

former_member189599
Participant
0 Kudos

hi Vadim!
I´m agree with you, but the client have the reason! jeje.
I'm going to try to persuade them that the solution you mentioned is the best.
Thanks you!!!

Regards.

LUCAS

former_member189599
Participant
0 Kudos

Hi Vadim!

Finally, I have today the meeting with the client. So, I going to expose your solution.
With this technic, all data will load in the system?Independently if the record was modified?
Thanks in advance!

LUCAS

former_member186338
Active Contributor
0 Kudos

"With this technic, all data will load in the system?Independently if the record was modified?"

My workflow in 1-6

assumes no modification of records (4)

If for some reason the modifications of data in the cube happened, then:

1. You suspect that data cache stored in template is incorrect (data changed in the cube).

2. Copy template to some temporary name.

3. Refresh copy without sending - the data cache will be synchronized with the cube.

4. In the original - change EVDRE_DATACACHE - from very hidden to visible and delete it.

5. Copy correct data cache from copy to original file.

6. Make EVDRE_DATACACHE in the original very hidden.

7. You will be able to correctly send data.

We use VBA code to perform 2-6, but can be done manually.

Vadim

former_member189599
Participant
0 Kudos

Hi Vadim!

Sorry, but I think I did not explain well the problem.
The problem is not that have changed the data in the cube.
The procedure that the client is as follows:

  1. Generate the template to be distributed.
  2. Distribute the template.
  3. Eliminate data cubes.
  4. Collect the forms.

As in Step 3, they delete the data, they want all records that are in the templates are loaded.
For example, when the template to be distributed is generated, if the cost center "X" is assigned a cost of "10" when it is collected and the user did not modify this value, the tool not up to the cube. Therefore, this data is "lost".

(Here it is where I think the cache participates)

Of course, that point 3 is not necessary, but they do this procedure. So I need to adapt the operation of the tool to the request.

I hope I have been clearer on this occasion.

Thank you once again.

LUCAS

former_member186338
Active Contributor
0 Kudos

Eliminate data cubes = change data in the cubes!

Can be solved by 1-7 from my prev. post... or if they clear all data - zero cache...

But sorry, it's absolutely unreasonable behavior...

May be they also reinstall BPC from zero? Or do some other strange things? Calculate parents with calculator?

Vadim

former_member189599
Participant
0 Kudos

Hi Vadim!

The client agreed with you!!

They are going to test it manually and if it is ok, then I have to program the VBA code.

(Maybe I will need help too!! haha)

Thanks!!

LUCAS

former_member189599
Participant
0 Kudos

Hello Vadim.

The client has taken time, but wants to implement the solution in VBA code. Could you please pass me a code example?

Thank you!!!

former_member186338
Active Contributor
0 Kudos

Hi Lucas,

You really want me to write a code for you? After I have already explained the idea of EVDRE_DATACACHE?

Sorry, but it's out of scope of the forum support! Do it yourself if you have a good VBA qualification.

Vadim

former_member189599
Participant
0 Kudos

Hello Vadim.
I understood that I had written code so I asked for an example, but I was wrong.
However, I have seen many times in this forum, people who not only publish code samples, but also for it to be implemented.
Anyway, I did not want to abuse your knowledge and time. I hope you can understand me and I apologize to you if it bothered my question.

Regards.

LUCAS

Former Member
0 Kudos

Hi Lucas,

Are you using the distribution feature? then you want to collect it automatically?

Those users don't have BPC access?

Andy

former_member189599
Participant
0 Kudos

Hi Andy.

yes, they are using the distribution feature and then they want to collect it automatically.

yes, those user don't hace BPC acces.

Thanks

LUCAS