Input Ready Queries (With plan data and real data)

[Former Member]

Hello,

I've created an Input Ready Query so the planners can plan by Cost Center and Cost Element. My Query has Cost Centers -> Cost Elements in Rows, and in Colums 3 years ahead to plan.

The Query is restrictes by two Variables that checks the Authorizations of the users by Cost Center and Cost Elements, so every user just see and plans their Cost Centers and Cost Elements.

My RealTime Cube has 4 Auth. Relevant Characterístics assigned to every Analisys Authorization already restricted by Cost Centers and Cost Elements. At the moment, the query runs perfectly well and every user can plan at will.

Example of a Authorizattion Analysis:

0COSTCENTER: 221xxx; 222xxx; 223xxx

0COSTELMNT: 621xxx; 622xxx

CO_AREA: *

0TCAACTVT: 02; 03; 16

0TCAIPROV: *

0TCAVALID: *

Now i was asked if it's possible to, in the same input query, see other Cost Elements that are not supposed to be planned by the User but he wants to see them. Like, having his assigned Cost Centers and Cost Elements ready for Input and others not ready for input. I thought this was going to be easy and i've created the following Authorization Analysis:

0COSTCENTER: 221xxx; 222xxx; 223xxx

0COSTELMNT: 631xxx; 632xxx

CO_AREA: *

0TCAACTVT: 03; 16

0TCAIPROV: *

0TCAVALID: *

Where i say, that he can see the same Cost Centers and can see the Cost Elements assigned it this 2nd Auth. Analysis. As you can see the Activity is restricted only to Execute and Show.

I've assigned these 2 Auth. Anal. to the user, but now when i run the query i get all the Cost Centers and all the Cost Elements assigned to him, but the Query is not Input Ready!

Anyone has any ideas on how to create this query?

Thanks

[gerd_schoeffl]

Hello Gustavo,

Your query in input enabled. Thus the system tries to open ALL record contained in the selection in 'read' mode (in one read statement). The end user has only display authorization for some of the records and thus the query is switched to display mode.

You could use a structure and set the input readiness for all the structure element(s) than display(s) the reference cost centers to display. The query will then make a distiction between the 'planning enabled part' and the 'display part' and will read data in 2 steps with the corresponding settings for input readiness.

Another option is to open all cost centers and then create a Exit data slices that blocks the reference cost centers depending on the user name. Then only the locked combinations will be inpout off and the other ones will remain open for input.

Best regards,

Gerd Schoeffl, SAP NetWeaver RIG BI EMEA

[Former Member]

Hi Vitor,

I have exact the same problem as you discribed in before. Could you please tell me how you solve that issue.

Many thank + best regards

Gustavo

[Former Member]

Vitor,

This kind of issue is due to the different authorized values are overlaping

Specifically the characteristics 0Costcenter and 0Costelmnt

Bear in mind that an input ready query must display an unique record from the aggregation level point of view

If this condition is not accomplished, the cells will not be ready for input

Try one of the following:

- Put both 0Costcenter and 0Costelmnt in the rows of your query in order to drill down, making the record unique. If the cells are able to input, you are done

- If not, it is possible you have to assign the 0TCAACTVT = '02' in the 2nd Analysis Authorization

- If you drill down in rows 0Costcenter and 0Costelmnt, but you do not want to see them, you could set their representation as "No display"

Rgds

Cesar

[Former Member]

Hi Cesar,

It works when I assign the activity 02 to both authorizations but that's what we don't want, otherwise users will have authorization to enter values for RIC_AUTHO = 222

Do you have any other suggestions?

Many tanks and best regards

Gustavo