4 weeks ago - last edited a week ago
Hi,
BW Gurus: Anybody has got a good solution ?
Finall Solution In Short: Delete in ob29 or SPRO the Fiscalperiod with too many entries ( if FI does not need it...)
The Problem:
SAP_BW 758 0001 SAPK-75801INSAPBW SAP Business Warehouse
Too many Query Paramater 0FISCPER:
This data originates from the 0FISCPER3 SID Table /BI0/SFISCPER3:
The 0FSICPER3 masterdata table /BI0/PFISCPER3 is fine:
Solution approaches and investigations which DO NOT WORK OUT:
This is not due to 0FSICPER3 is using local implementation class CL_RSMD_RS_0FISCPER3:
Reinstall the 0FSICVPER from the RSA1 / Business Content wont help.
Rebuild the data with RSRHIERARCHYVIRT, wont help:
RSDMDD_DELETE_BATCH won’t work because it’s the SID table.
Hard delete the obsolete in the SID Table /BI0/SFISCPER3
DELETE FROM /BI0/SFISCPER3 where CHCKFL <> ‘X’ and FISCPER3 = '365'.
Dont do this You cant edit the Masterdata ADT afterwords even If You do an update with the
same thing again.
SAP OSS Recommendations are:
https://me.sap.com/notes/801313/D - 801313 - Questions about queries based on virtual InfoCubes:
Fits only for physical: Cubes
https://me.sap.com/notes/801313/E 801313 - Questions about queries based on virtual InfoCubesNice summaray on the modes of a Infobject, Provider, Queery, but did not do
https://me.sap.com/notes/1565809/E -1565809 - BW Query Input(F4) Help: Settings and Properties
not if You have Composite Providerrs: the annotation could do it : "...in certain cases "
Change the table rsadmin to changeable in SE11.
Enter bei RSADMIN manually RSMD_READ_MODE_D_FOR_VIEWS X
This one worked oút
Mind: the setting is centrally for all and any querry on You box !
Coal Pit of 1565809 - BW Query Input(F4) Help: Settings and Properties
TheAfO Query FSICPER F4 lookup gets fff slow.
Finally we tracked it down to the setup of the Fiscal Period:
OB29 or SPRO
We deleted the entry FISCPER = DL with 365 Days (after checking with the FI guys if its needed at all) and got only 52 remaining.
We deleted the entry FISCPER = WK with 53 and FISCPER = WK 24 Days (after checking with the FI guys if its needed at all) and got only 12 remaining.
...but 0FISCPER3 SID Table /BI0/SFISCPER3 did not change convicingly: (compare above):
Alternative:
Base the 0FSICPER3 on a HANA Calculation View and Calculation View with the DE / EN Texts
with static 12 lines ( ...union ....)
Done. However.
Best Martin
Request clarification before answering.
Cleared of Content
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
48 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.