I've used this forum to solve my issues or questions I had, successfully, until now.
What I want to achieve:
I do not want to touch or sum up values in a Cube for a Date that is older than the day before yesterday (previous period). These values have to stay untouched and unchanged.
But this does not apply for all the data stored. I also have variable Elements, which need to be updated even for older Dates (periods) daily.
Right now, I'm running a ZeroOut process that clears all these variable Elements, which allow me to have updated values daily, which is not a sum of all periods the cube has been updated(this one does work without issues).
For my other criteria, I'm using a CellIncrementN (see code below), which unfortunately is adding values to the day before yesterday. I hope you guys can help me out with this one.
Code: Select all
CellincrementN( (1), csCubeTarget, csDateAP, vCountryName, vPatientNum, vPatStatusDescr, psInput, psValue);
vPatientNum is a SerialID, vPatStatusDescr is a Description of the Product, psInput is either manual or automatic and psValue is either String or Numeric.
I guess this one line of code is not sufficient to fulfill the requirements of my needs. But my thought process behind that was, if I'm able to grab the date of yesterday (i.e. Aug 24th), usually the CellincrementN should only write values to the specific date Element, right? Instead it is adding values to days before yesterday, instead of "skipping" them.