Home > > Query Jump Restriction

Query Jump Restriction

I have a query that provides the cumulative balance for the month figures for a GL selction structure.I do a query jump into anoother query that shows debit and credit values for the characteristic selection based on where the user clicks on the report. Now is there anyway that I can selectively restrict the jump? For instance, I have a column for For the rep period, another for for the comparison period, and then there is a variance column too. Now is there a way that I can disable jump when the user clicks the variance column (the variance is of course a formula element in my structure)?
Thanks for the reply.
I have the foll in the rows and columns and I need to restrict like this:
Sales-Third Party (Selection based on hierarchy node)
Sales-Affiliates (Selection based on hierarchy node)
Net Sales (Formula)
For the rep period     For the comp period     Variance
Now I want to disable query jump for the following because these elements in the structure will not be passing the right values to my jump query.
Row: Net Sales
Column: Variance
How do I do that?
Is there any workaround or if not is this kind of a feature available in NW04s?
Message was edited by: Anand Nataraj
Read the other 10 answers
Hello, I have query jump from Q1 to Q2. The result in the Q1 is in EUR. when I jump from Q1 to Q2 it is automatically filling Currency filled with USD and key figures are showing NOT APPLICABLE DATA. Once you remove the Currenyc USD then it is showin
Hello Gurus, I have created Query Jump (RRI) using Transaction RSBBS. I have assign 3 query.In Development its working fine one can jump from one query to another,my problme is that after transport this query jump links are missing although query are
Hi All, I have more than 50 Params on Screen to be inserted into database through MII Solution 1: I can send this as one param by selecting all the variables in one variable (through dynamic SQL Query) but this is not good practice as it is is not se
Hello, I have created a query jump in the RSBBS transaction to go in R/3 through a Bex Query. When i choose the jump in the query anayzer I have the error message: <b>No Web server maintained for the presentation of log. system.</b> Do you hav
Hello, I have created a query jump in the RSBBS transaction to go in R/3 through a Bex Query. When i choose the jump in the query anayzer I have the error message: <b>No Web server maintained for the presentation of log. system.</b> Do you hav
The Content activation of Query jump targets(transport object RRQA) does not work. This problem was caused by a program error in function group RSBBS2.... Anyone please help me out as I am new to this  domain....Refer to this....might help you.... BW
Hi All.    We have 4 BEx queries in our Dashboard Web Template and each table web items shows 10 rows and remaining with Scorll.    For Printing ,we have created a query jump for each BEx Query ( same copy query) that shows all the rows detail.    Wh
hi all, i am new to bw what is the query jump start? plz send me ans Reg sreeHi Matthias, thanks for your reply. Yes, we are almost sure that, so far, is not yet possible to recover, from outside, changed data in the context of a particular planning
hi,       Can any one tell me what is "query Jump start"Oscar, Q2 as Currency in Free Chars.... I removed it from the Q2itself and it works fine. but I am unable to understand the reason. Even though this works - I need to give reason for removi
Hallo Experts, I would like to restrict key figures after user has beeen prompted to enter a date. I have 2 key figures: a) KF1, Date1 b) KF2, Date2 User should be prompted to select a specific date: e.g. 01/2011. After selecting/entering the prompte
Hi developers, we have problem because we have created a variable time on 0CALDAY who is mapped in the cube of the stock with posting date.We launch the query for example with range 01/8/2005 31/8/2005 and the resul is OK. Then we jump on the other q
Sorry not really an easy thing to explain: I have specified in a Query that i Only want values with a date BETWEEN: 01JAN2002 08:00 AND 01SEP2003 08:00 Now in the same query, what is the simplest way to restrict that only the following dates are exam
Hello All, Is possible to restrict SAP SQ01 Query report at Plant level? I mean if it can be restricted through Auth object at Role level?Hi, OK, when a query is created you can hard code selection parameters into the query itself (i.e. default in th
Hi  all, While activating the Query we are getting error , the object is missing in active version  ? And also it is not allowing to open the query  how  to activate the query element now? Also restricted key figure is inactive and how to activate th
Hello all, My requirement is to jump from one query to another two queries. The sender comes from infoCube A and receivers comes from ODS B and ODS C (ODS C is a copy of ODS B). The problem is that when I execute the first jump a pop up appears with
Hi everybody,     I have prb with a query. I have created a query and infoset. I have join tables .. and I would like to add condition of clause 'where' to restrict the result of query depending on the dates. Those dates are not given in the selectio
HI SAP Guru's I have scenario here where the multiprovider is made up of 3 DSO .....i have a infoobject 0CRM_OBJ_ID(transaction Number) in two DSO and i want to display both values in separate rows as AMC Number and Service order Number in the query
Hi coul you please suggest me how can I trace the jump from a query to another? thanks for the cooperation!    StefaniaPlease see the documentation for OLAP trace. http://help.sap.com/saphelp_nw04/helpdata/en/cb/f91c3d2b058c4ce10000000a114084/content
Hi, We are using content search query to query the data from search index. We wanted to restrict the number of items returned in the query to 5. so that we can sort the items with priority column. Please let me know if there is any syntax that i can