hello
do you know exactly what is this warning I didn't find anything on google?
I only have one version of fact tables...
XQE-WRN-0042 Join optimization: used the alphabetically first fact table: '(en-zw) CA' from the selected fact tables '(en-zw) CA, (en-zw) PAX Référence, (en-zw) Revenu, (en-zw) SP35, (en-zw) fct_ca, (en-zw) fct_customers, (en-zw) fct_events, (en-zw) fct_fees, (en-zw) fct_receipts, (en-zw) fct_surfaces' .
The best advice will come if you provide sufficient details. Take a look at the forum etiquette post for some ideas on things you can provide that will help.
Otherwise we can just try to guess. The only thing that comes to mind is that you are using a relational package and attempting to produce a report that includes query items from two different dimensions but does NOT include query items from any of your fact tables. Therefore it needs to pick a fact table arbitrarily to achieve your request, specifically the first one alphabetically.
Quote from: Avisto.sbu on 07 May 2014 10:25:51 AM
hello
do you know exactly what is this warning I didn't find anything on google?
I only have one version of fact tables...
XQE-WRN-0042 Join optimization: used the alphabetically first fact table: '(en-zw) CA' from the selected fact tables '(en-zw) CA, (en-zw) PAX Référence, (en-zw) Revenu, (en-zw) SP35, (en-zw) fct_ca, (en-zw) fct_customers, (en-zw) fct_events, (en-zw) fct_fees, (en-zw) fct_receipts, (en-zw) fct_surfaces' .
It looks to me like you might be writing a report that brings in data from two dimensions but no linking fact? If so, then there are potentially many fact tables that could be used in the join strategy (assuming the dimensions are conformed and link to multiple fact tables) The warning looks like a message indicating which fact table is being used.
MF.
Sent from my iPad using Tapatalk HD
Quote from: MFGF on 07 May 2014 12:04:58 PM
It looks to me like you might be writing a report that brings in data from two dimensions but no linking fact? If so, then there are potentially many fact tables that could be used in the join strategy (assuming the dimensions are conformed and link to multiple fact tables) The warning looks like a message indicating which fact table is being used.
MF.
Sent from my iPad using Tapatalk HD
JINX!! You owe me a coke :)