on 05-07-2010 9:57 AM
Hi Experts,
when i try to execute the query in bex analyzer, i am getting the below error
Formal error in query definition (DIM <->FROM [NAV]
Query couldnot be opened
please tell me am i missing any settings in query designer
Regards,
Marasa
Hi,
You should start by checking your query definition thoroughly. Do you use any formulas, filters on navigational attributes, ...?
Regards,
Sarah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1417882
Symptom
Changing of a reusable Filter may cause the error message BRAIN 449 with the text "Formal error in query definition (DIM <-> FROM[NAV])" during generation or execution of the queries containing this Filter in the definition.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think there is some problem with any of the formula or calculated key figure. Open the query in query designer and check all the formulas and calculated key figures.
You can also try generating the query in RSRT. RSRT --> Give query name --> click on "Generate Report".
You can also check OSS Note 1417882.
Edited by: Pravender on May 7, 2010 2:41 PM
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.