Advice on flipping sign on large historical data set? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Advice on flipping sign on large historical data set?

Summary:

I am looking for advice on flipping the sign of a very large historical data set within our application (likely many millions of blocks).

Content:

We have an inconsistency between our various planning applications (different pods) where cost data is treated as positive or negative depending on the application, and the consolidation operators in the Account hierarchy reflect as such. Our goal here is to flip the sign on all cost data in one application ("cost" defined by specific Account members). We have both a BSO cube and an ASO reporting cube in this application. I am trying to see what options would be best. From what I can see, below are my options:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!