This content has been marked as final. Show 2 replies
I am facing a wierd issue while trying to push data to ASO using Smart View. I am not sure if this is specific to 184.108.40.206 SV or Essbase. For test purpose I used sample ASO app which comes with Essbase installation
1. Bring all Level 0 accounts on to rows and months on columns
2. Select all level zero members from each dimension in POV
Now if you try to push data to "Original Price" and it gets submitted correctly but if I try to push data to formula member "Avg Units/transaction", the value gets assigned to Transactions (member just above formula member)
Now if we remove transactions from there, then whichever is the nearest non-formula member, its value gets overwritten with value.
Question: Why is the value getting assigned to nearest non-formula member. If I push data to formula member, it should get ignored and not assigned to nearest non-formula member
Observation1 : This behavior is observed in 220.127.116.11 and not with 18.104.22.168
Observation 2: If I try to push data ( two diff values) to both Transactions (nearest non formula member) and Avg Units/Transaction (formula member) then it prompts Essbase error 1270089: Data load failed: input contains different values for same cell
Can anyone please provide some explanation or have encountered similar issue ?