1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How dynamically genrate result set in OBIEE 11.

Discussion in 'Oracle Forms and Reports' started by aamir123, Oct 19, 2011.

  1. aamir123

    aamir123 Active Member

    Likes Received:
    Trophy Points:
    I have variable in OBIEE 11 dashboard report that contains a comma separated string
    represented by Fact table columns as below are 3 columns of Fact table Unique Clicks, No of Prospects,
    and Email Sent Count

    Var = “Fact”.”Unique Clicks”,”Fact”.”No of Prospects”,”Fact”.”Email Sent Count”

    Now I want to separate these columns and generate columns of result set in OBIEE 11 dashboard report

    In other word dynamically generate result set columns.

    Can I do through java script, changes in analysis XML shown in Advanced tab etc any syggestion.