About jez_lawson

jez_lawson

Hi Experts,I am looking to fully refresh all data in our Sandbox system with Production data. A key part of the refresh is to only have planning objects in the Sandbox that are in Production (so deleting any planning object that does not exist in pr...

jez_lawson

Hi Experts,I am trying to create a KF where the future periods show a forecasted value and the historical periods show a forecast that is stored in lag key figure. I have not been able to determine if it is possible (and if so how) to refer to a spe...

jez_lawson

Hi Experts,I am trying to merge a currency based planning objects using CPI-DS. The current planning level is Location/Customer/Product/Currency and I currently have multiple currencies per Location/Customer/Products. I wish to combine these into a...

jez_lawson

Hi Experts,The SAP recommendation is to have a single currency planning object at a base planning level. When we set up our initial model we were not aware of this recommendation and as a result we have hit a couple of issues with how our data aggre...

jez_lawson

Hi all,We are experiencing a substantial number of Excel planning view favourites corrupting and crashing Excel when you attempt to open them. Often we can fix the views by sharing them with another user in Content Administration, they can then ofte...

jez_lawson

Hi Phil,We had this exact same issue. We were having CustomerA and CUSTOMERA being treated as separate values (and inconsistent as to how it showed on different planning objects), so filtering was giving us terrible results. We fixed it at source b...

jez_lawson

Hi Micbur,I am really late to the party here, but I searched looking for help (and there isn't much out there). I have subsequently managed to get this working.Add a Row Generator with a count of 2.In table 1 add a field TheKey with a value of 1In t...

jez_lawson

SAP note 3320458 fixes the problem.

jez_lawson

Perfect, thank you Gaurav.

jez_lawson

The issue is resolved. I put an incident in with SAP, I do not have details as to what was changed but I was advised the error should stop and it did indeed stop. Sorry for the lack of details, but if you get the same issue put an incident in and S...

User Statistics

User Activity

Is it possible to do a full data refresh in a Sandbox client from a Production client?

Using a Lag key figure in the calculation of another key figure

Can I include snapshot key figures in my planning are CPI-DS staging table for upload?

How to run IBP realignment between currencies

IBP Excel Add-In corrupted planning view favourites.

Re: IBP Excel Case Sensitivity

Re: In CIDS how does one merge data from 2 tables but hav...

Re: IBP Excel Add-In corrupted planning view favourites.

Re: Set IBP Error "Cycle detected in SCM Network" to Warning

Re: Connection Error generating but job processing successfully