on 10-15-2015 9:39 PM
Hi All,
We have Summary report and detailed report, both are on BEx query. Both queries have 'Code' variable. selected two codes for summary report and below data is displaying in summary report
Country | Amt |
C1 | 500 |
C2 | 1000 |
created a hperlink on country column using wizard (not through hyperlink syntax) .
Since it is BEx query, so passing Code_Key detail object to Code variable..
Issue is.. after creating hyperlink summary report data is changing like below as amount is not aggregating and displaying separately for each code.
Country | Amt |
C1 | 200 |
C1 | 300 |
C2 | 450 |
C2 | 550 |
I tried to pass the code_key to code variable using Userresponse() like below then it is displaying correctly.
if(Userresponse("Code")="abc";"10";if(Userresponse("Code")="xyz";"20";"10;20")
But we have many codes and user can select any combination, so I think userresponse() is not the option. Can you please help me why it is not displaying aggregated data when Code_key detailed object is passed to ‘code’ variable? What I am doing wrong here to pass multiple values..?
Thank you,
Suri
Hi Suri,
Is the issue resolved?
Anyways use Group by clause in the formula. Like ForAll(Country) or Foreach(Country).
So the amount gets grouped based on the Country.
Now for the hyperlink, you should pass the Country code alone and along with the prompt values if you have for the detailed report.
You need to have same prompts at parent n detail levels.
Grtz
-Anila.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anila,
Thank you, I tried below...
= Amt ForAll(Country)
= Amt Foreach(Country)
= Amt in (Country)
used sum() also, but no luck..
Hi Sateesh,
we have 2 prompts(For ex: Yr and Country) in summary report and we have MGroup, Qty data available in query
Above same 2 prompts and MGroup prompt are in detailed report and we have Mgroup, material, Amt data available in query.
Now can't we pass the selected Yr, multiple Country values and on click value (MGroup) in summary report to the detailed report?
Hi,
In my search regarding multiple values passing from summary report to detail report....
I found few threads that we can pass only hard coded multiple values to detail report, but we can't pass multiple values dynamically to detail report.
Can any one confirm please....is my understanding correct?
This scenario is webi report on BEx query (BO version BI4.1 SP4)
Thank you,
Thank you Neil, but my report is on BEx and also that Alerts will not fulfill my requirement.
Hi All,
Is it not possible in webi to pass multiple values dynamically from summary report to detail report??
here Dynamic means: I want to assign Object instead of hard-coding values..
Please comment and suggest on this scenario as I found in my search that it is not possible..please correct me if I am wrong...
Thank you,
Hi Suri ,
Webi will add the dimension in hyperlink also to the context. This is the product behavior .
Since you have many codes for each Country , rows are getting to detailed level with extended context
To avoid multiple rows , you can take out the code key from hyperlink and provide prompt for the same in child report .Pass only Country to child report !!
or
add the code key object in the table in main report , so that users will be absolutely knowing for which country and code they want to see the report .!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
U can make it in the Bex Queries..
U can use formulas in Bex Level itself..Try it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I am not sure whether you understand the issue correctly.
Data is displaying correctly like below without hyperlink:
Country | Amt |
C1 | 500 |
C2 | 1000 |
Issue is, when I try to create the hyperlink on Country column (passing Country value using country object and 2 Codes using Code_key detail object) then data is changing like below:
Country | Amt |
C1 | 200 |
C1 | 300 |
C2 | 450 |
C2 | 550 |
Actually above data is at code level like below,
Country | Code_key | Amt |
C1 | 10 | 200 |
C1 | 20 | 300 |
C2 | 10 | 450 |
C2 | 20 | 550 |
but as mentioned I am expecting same table without Code_Key like below and with Hyperlink on Country column
Country | Amt |
C1 | 500 |
C2 | 1000 |
I am not sure why this issue is occurring when I pass the codes using Code_key detail object.
FYI, if I pass the one code_key using userresponse() like below then it is displaying correctly,
if(Userresponse("Code")="abc";"10";if(Userresponse("Code")="xyz";"20";"10;20")
but scenario is, user can select multiple Codes in main report and detail report restrict accordingly
BO version: BI4.1 SP4
Hope you understand the issue now... appreciate your help
Thank you,
Suri,
Try creating a variable which stores all the Code_key values per country and displays as
Country | Amt | Code_Key |
C1 | 500 | 10;20 |
C2 | 1000 | 10;20 |
Create the hyperlink based on Country and the new variable.
Use the below link for creating the variable.
bi.scribe: Converting rows into a single cell (comma separated list) in WebI
If its just 2 values 10 and 20 then you can just use
MAX(Code_key)In ([Country])+";"+MIN(Code_key)In ([Country])
-Sri Harsha
Hi,
Why are you creating hyperlink on Country column? Just apply hyperlink on Amt column.I mean apply hyperlink on measure object instead of dimension objects.
So for measure object you can apply aggregation in If condition like
if(Userresponse("Code")="abc";Sum(Amt);if(Userresponse("Code")="xyz";sum(AMt)) etc.
Thanks,
Swapnil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Swapnil,
Thank you,
Sorry, I forgot to mention that detail report has Country variable also as I need to pass both Country (which ever country I click on) and Code (which are selected in prompt)
As you suggested I tried to create hyperlink on measure column, but it is displaying #MULTIVALUE.
And I didn't understand why we need to create below formula which you suggested for measure.
if(Userresponse("Code")="abc";Sum(Amt);if(Userresponse("Code")="xyz";sum(AMt)) etc.
Also as I mentioned we have many codes and user can select multiple values for Code..
Thank you again,
User | Count |
---|---|
85 | |
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.