I am trying to use an external resource table from Excel and add it to a Bex Query WEBI report. I follow the many blog post instructions on adding an Excel query, merging the like field, and creating Detail variables of the fields from the excel table, using the merged dimension as a reference. This all works properly.
Some of the fields in the excel table are numerical (measures). When I create detail variables of these measures, to create the relationship to use with the Bex query fields, they are no longer measures, thus I am unable to create graphs, using these numerical fields from my excel table on the value axis.
My question: is it possible to have numerical values (measures) in an external excel table and be able to bring them into WEBI to use on a graph, along with fields from the Bex query? If so, how do I do this when I have to make the measures into detail variables to be able to use?
There is no need to create detail variables for measure objects.you need to create detail variables for those dimension objects which are not common in both queries.
Merge common dimension objects and if some are uncommon then create detail variables for those.drag measure object as it is in the chart.