Copying across planning areas
I have transactional cube (planning) and a basic cube (actuals) with their own planning areas, and rolled-up to a mutli-planning area.
All Im trying to do, is simply copy the actuals from the basic cube to my transactional cube, so it forms the basis of my plan in my transactional cube.
<u>In the Planning Function (Copy)</u>
Fields for Condition: = Planning area
Fields to Be changed: = Version
Planning Area = defined the planning area containing my basic cube that contains actuals.
Version = From: # To: 001
For some reason this is not working. When I run it in trace, its not reading any records from the basic cube (and there are thousands of records there).
Am I missing something here..?? Did I define the condition and fields to be changed wrongly?