The universe consists of dimensions and metrics, which are imported directly from the BEx query. Other metrics, for Year-to-date calculations, are developed in the universe with resort to MDX expressions.

hi Frnds, In a newly created Bex Query , i created a variable , dragged it under the corresponding char , but when i am executing the query , it is directly going into the results with showing that va

Hello all, I had to modify a formula in a Bex query to have it calculate the results of formula by summation. I checked the query using Business Objects Analyzer and it summed correctly. If I create …

We have a Bex Query 7.0 in Portal 7.3. We need to select for example a Document Number from the query. That number must be saved in a parameter in Portal so the user can trigger another action in …

After upgrade bw 7.0 to 7.4 we have a issue in some queries bex only in some queries.

Can some one tell me the difference in performance of an embedded Bex Query result in a spreadsheet compared to a SAPGetData formula? Thanks, Alvin

May 26, 2016 · If the end-user run the query for this MP and he will receive the value for 0COMP_CODE (authorization Variable), the query reads all Cubes instead of only the dedicated corresponding to the …

I am creating a query from an ODS and noticed that there is something called query view !!..when do we create a query view and whats the use of this ? Please help

i need to create a calculated field to have average per day , to do so I need to know how many days in the month within the TIME field

The changing of query for an OLAP connection is something that you can't do in e.g. Web Intelligence or Dashboards (Xcelsius), Design Studio is the first place I have come across that possibility. Have …