Page 1 of 1

Copy Process

Posted: Wed Aug 29, 2018 1:39 pm
by Jorge Rachid
Hi guys,

I have a process to copy data from one cube (calculated version) to another one (historical data), but the problem is when I do this copy using a view from the first cube as source, the value that is copied is diferent. This could be a feeder problem?

I checked all values using check and trace feeders and everything seems to been fed correctly.

Find below screenshot between source and destionation cube:
img_1.JPG
img_1.JPG (57.11 KiB) Viewed 3125 times
Now another one showing that values on source cube are fed:
img_2.JPG
img_2.JPG (96.98 KiB) Viewed 3125 times
What could be wrong on this case?

Thanks a lot for any help.

JR

Re: Copy Process

Posted: Wed Aug 29, 2018 2:42 pm
by qml
It would be helpful to see your TI code.

A few questions:
- Are the rule-calculated values in the source cube at the N or C level?
- What are the following extract settings for the source view in your TI:
ViewExtractSkipCalcsSet
ViewExtractSkipRuleValuesSet

The reason I'm asking is that it's possible that you could be taking real underlying values from the cube rather than the rule-calculated ones which you are seeing in cube viewer.

Re: Copy Process

Posted: Wed Aug 29, 2018 2:42 pm
by Wim Gielis
Hello,

Limit your selections in the Source cube (to isolate the issue better) and use AsciiOutput in the Data tab to write contents to a text file.
For 1 year, period, ... that will certainly give you pointers.

Re: Copy Process

Posted: Wed Aug 29, 2018 6:08 pm
by Jorge Rachid
Hi,

I used your tips and I found the error.

The problem is on source view, where I was using two elements instead of one. I changed it and worked.

Thanks a lot.

JR

Re: Copy Process

Posted: Wed Aug 29, 2018 6:33 pm
by Wim Gielis
Well done !