on 02-25-2005 7:47 PM
Hello,
Is there any possiblity in BW to generate a MDX statement using a BEx query?
Thanks,
Ravi
You can use MDXTEST transaction to generate the default MDX select statements against query or infocubes. Note: make sure you release the query for OLAP ( this technical attribute has to be checked for query in Query Designer)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
BW does not generate any MDX statement for Bex query.I have tried ample number of times to acheive this but failed.
Like an Infocube the Query is also an object where in you can write MDX queries on BEx Queries.
As it is I never found BW rendering MDX queries.But with MDX queries you can get something but how far it helps I don't know.
RSCRM_BAPI is obsolete and it is recommended to use RSCRM_REPORT somewhere I have read ,but when I went to that transaction I never found that "MDX" button at all.
It was converted to "OLAP Check" which gave me some warning on the key figures and that's it.
Somehow I feel BW is not comfortable with MDX.
Regs
Gopi
Hi Ravi,
I normally user RSCRM_BAPI and execute the query..then I get a popup whether I want to see MDX statement or not..if you choose display MDX option then you can see the MDX. You can remove the generated objects with proper object names and test it using MDXTEST transaction.
Hope this helps..
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
transaction RSCRM_BAPI is doing this.
In some cases this is very complex.
reg.
michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, you can use tcode MDXTEST. There you will be able to select the queries, generate MDX statements and display results.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.