How do you create an opendoc measure and pass prompt parameters
I need to create 2 measure. First measure for wages, which will be summed up by 4 group levels. on the 5th group I need to pass the same wages measure as view but then when the user click on the drill on this measure it will change to a new measure called wagesdrill, this new measure will be an opendoc link to a second universe, which i will need to pass over the variables, project id and work id, year and month.
How would you create the wagesdrill measure opendoc link and how would i pass these 2 variables in the 5th group level.
Someone told me they have done this but would not share how. Is there anyone that can shed somelight.
My problems is i have 2 universes, universe has the all the data except my detail data, that is coming for a different database and that one is my second universe.
Jacques du Preez replied
You can create the links in the Webi Reports as a valiable...
For XI R2
For XI R3
Not sure, but I think you could find somthing here... [http://help.sap.com]
or search the Web Intelligence forum for "opendocument".. here are plenty of threads and examples.
Hope this helps