Getting the below error while loading the data into ASO cube,
' Aggregate storage applications ignore update to derived cells.  cells skipped'
Reason is loaded the data against higher level members instead of level '0', this is just message in log file and finally getting loading successfully with out any error/rejects in error file.
But we are unable to identify the skipped member names(544 record)/ skipping message in error file while loading, later business found that some data got missed.
How to redirect/handle this skipping message with skipped record names to error file as error/ rejection/alert to identify while loading.
Please share your experience / knowledge on this issue if you faced before.
It's aso cube in which we are not suppose to load/manually enter data on parents level.everything has to be loaded on level 0 only. Error message has creally mentioned that.
So for missing or wrong data you need to check input file.
For error file we will get message for other errors but not for skip values.
Thanks for your reply Shiva,
it is difficult to identify which 500 records are skipped in my input file out of 50,000 records. Is there any way to identify missed records rather than manul process?
can we set any alert mesage/ warning/error in error file for skipped data while loading?
I don't think it'll record the skip values. If you really want to avoid those then you'll have to have a creative mind
If you know what are the parent members, then it is easier else you'll have to get an extract and perform a lookup and see the entries with higher level data.
Generally (with only 50,000 records) I just keep deleting the bottom 1/2 of the records until I only have 1 row rejected
Then keep splitting that in half till you find when it goes to 0 then back up and take the 1/2 you just deleted and work with them. Repeat this step till you have only 1 record in file and that is rejected. You will generally realize what your error was for the other 543 records.