Hi everyone,
Need a little help with BSO to ASO conversion. This is the first time I'm attempting to convert a cube from BSO to ASO. I used the conversion wizard, and I was able to convert all my outline formulas to MDX successfully. The outline verifies.
But, the conversion cleared the data out of the cube, and I'm having trouble trying to load the data from a zero level export file created from the BSO cube. This is the message I get after the data load:
Parallel dataload enabled: [1] block prepare threads, [1] block write threads.
Aggregate storage applications ignore update to derived cells. [2.20705e 006] cells skipped
Data load stream contains [14658] zero and [3.1641e 007] #MISSING cells
Data Load Elapsed Time : [10.781] seconds
Database import completed ['FIN12AGG'.'Core']
Output columns prepared: [0]
I ran an aggregation after the data load, but when I try to retrieve data from the new cube, I get all zeroes. Data Preview in EAS shows all cells at #MISSING.
Can someone please tell me what I'm doing wrong?
Thanks!
Ana Lawton
Financial System Analyst (PTNA/CTG4)
Robert Bosch Tool Corporation
1800 W. Central Road
Mount Prospect, IL 60056 USA
Tel: 1-(224)-232-3126
Fax: 1-(224)-232-3092
[email protected]