Skip to Content
0
Former Member
Apr 11, 2008 at 01:57 PM

Input Ready Queries (With plan data and real data)

19 Views

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