Hello Experts,
There are two questions on the CLOUD DM to ASO CUBE :
1. File load using DM to ASO : Getting the below error while loading the data and this Member Exists in the target app ASO.
Solution Tried : This member along with all others are in shared hierarchy as well and it is very impossible to give a fully qualified name on a mapping(Exceeds more than 25 char and many levels)
2019-06-24 23:44:42,570 INFO [AIF]: Replace data script:
CROSSJOIN({[Year].[FY19]},CROSSJOIN({[Period].[Apr]},{[Entity].[90302_9031],[Entity].[79508_7101],[Entity].[85201_8054]}))
2019-06-24 23:44:42,590 DEBUG [AIF]: Unlocked rule file: AIF0053
2019-06-24 23:44:42,591 INFO [AIF]: The load buffer [1] has been closed (finally clause).
2019-06-24 23:44:42,591 ERROR [AIF]: Cannot Clear Partial Data. Essbase Error(1260046): Unknown Member [Entity].[90302_9031] used in query
2019-06-24 23:44:42,597 INFO [AIF]: EssbaseService.loadData - END (false)
2019-06-24 23:44:42,606 DEBUG [AIF]: AIFUtil.callOdiServlet - END
2019-06-24 23:44:42,607 FATAL [AIF]: Error in CommData.loadData
Please suggest me some idea to get through this.
2. EXTRACT from Cloud ASO cube:
Having a dimension as CSG and want extract only the member TOTAL_CSG(dynamic) , which inputed as "TOTAL_CSG" under source filter. Whatever value I passed on that filter is getting me all the members under this Member(TOTAL_CSG).
Solution tried : @MEMBER("TOTAL_CSG") , @LIST("TOTAL_CSG")
Please suggest me some idea to get only the Parent member.
Thanks & Regards,
CA