Skip to Content
avatar image
Former Member

issue with data display

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 15, 2015 at 09:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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,

  • avatar image
    Former Member
    Oct 16, 2015 at 05:06 AM

    Hi,

    U can make it in the Bex Queries..

    U can use formulas in Bex Level itself..Try it

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 11:13 AM

    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 .!!

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 01:50 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Neil Mitchell-Goodson

      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,