on 09-11-2015 1:27 PM
Hi All,
I am trying to implement comment option within planning (BW on hana 7.4/SP9) - and have created a DSO(planning enabled)/in which the comment object resides - also as a characteristic as keyfigure. So far so good but according to the documentation it it advised to use a multiprovider scenario with an aggregation level on top.
The first part (linking into a multiprovider) doesn't work for me - the folder "Characteristics as keyfigures" is shown but there are nothing when I expand it. Instead of that I tried to directly use an aggregation level on top of the planning dso. That worked better - the generated keyfigure is shown and the aggregation level was ok. I built the input ready query but that part doesn't work. When executing the query from RSRT it comes up with the following messages:
Error message View attribute "Z_COMM_SID" was not found in schema/[Request Info: Object Name = "<schema>"."0BW:BIA:<dso>", FM Name = ...
Error message TREX_DBS_AGGREGATE]
Error message Error 2.018 has occurred in the BWA/SAP HANA server
Error message Error reading the data of InfoProvider <dso>$X
Error message Error reading the data of InfoProvider <dso>$A
Error message Error while reading data; navigation is possible
Information Message Object Collapsed >> Row: 79 Inc: MAP_TREX_EXCEPTION Prog: CL_RSDRH_TREX_STORAGE
In SM21 - the following message is generated:
X MESSAGE BRAIN 299: CL_RSPLS_AI_BUFFER_STORE_A _READ_DB-03-
I tested various settings on the query properties as stated in this thread Still no luck.
Ideas, suggestions will be appreciated 😉
/MiB
Ok thanks.
I'll let you know as soon as I have the solution to the problem.
Good luck
Regards,
Amir L
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please tell me if you have find a solution for the issue.
I had exactly the same error after an upgrade of BW HANA 7.4 sp8 to sp11. My issue is on the characteristic 0COMP_CODE and another one.
I have also opened a problem ticket but I have not yet received an answer
Thank you for your help
Regards,
Amir L
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amir,
Thanks for letting me know I am not the only one 😉 - I will try to keep you posted. We have one system where it is "kind of working" and the other one where it is not working at all (we are on sp9 and adding notes).
Timing is a bit critical for us so we have started a parallel track (creating the tool using XS and SAPUI).
/MiB
Hi Michael,
having a characteristic A in the data part of a planning enabled DSO one can expose the characteristic as key figure (cf. the corresponding folder in the DSO maintenance). The key figure (kind of 'virtual' since it is not contained in the physical DSO) has the technical name 1KYF_A. In a MultiProvider or Composite Provider one can then use this key figure 1KYF_A as usual; in these InfoProvider something like the 'characteristics as key figure' folder is not needed. So use 1KYF_A as usual and maintain the mapping.
To your problem you described:
1 Try to recreate the index using report RSDDB_LOGINDEX_CREATE.
2 Maybe also buffered meta data are wrong; try to recreated the meta data buffer for the DSO and the aggregation level using report RSR_MULTIPROV_CHECK.
If this does not help open a problem ticket.
Regards,
Gregor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.