Question:
Hi Folks,
Is it possible to make adjustments to the ODS data and store it in the database level before dumping into the cube? For example, if I want to massage the data using some calculations or formula and I want to store the adjusted figure in the cube, what implications are involved?
Thanks in advance.
Answer:
you can do this in the update rules from ODS to cube.