Author |
Topic |
anil2007
Starting Member
5 Posts |
Posted - 2008-01-09 : 03:44:37
|
Hi all,i am working on data warehousing and creating derived tables with sql.... I am geting error like this Each Calculated column must have an explicit name Can you please help me on thisSELECT OMEGA.V_ADH_CETROOT_S.ABS_MONTH, OMEGA.V_ADH_CETROOT_S.EMPLOYEE_ID, OMEGA.V_ADH_CETROOT_S.OWNER_CHAIR_ID, OMEGA.V_ADH_CETROOT_S.CHAIR_NAME, OMEGA.V_ADH_CETROOT_S.COUNTRY_MCODE, OMEGA.V_ADH_CETROOT_S.SOURCE_TRANSACTION_CID, OMEGA.V_ADH_CETROOT_S.ORDER_REVISION_NUMBER, substr(OMEGA.V_ADH_CETROOT_S.REVENUE_DATE,1,10) Revenuedate, OMEGA.V_ADH_CETROOT_S.CUSTOMER_POSTAL_MCODE, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_NAME, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_CID, OMEGA.V_ADH_CETROOT_S.PRODUCT_CID_07, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_11, OMEGA.V_ADH_CETROOT_S.PARTNER_NAME, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_07, OMEGA.V_ADH_CETROOT_S.ORDER_DATE, OMEGA.V_ADH_CETROOT_S.CUSTOMER_PURCHASE_ORDER_CID, round(OMEGA.V_ADH_CETROOT_S.NET_AMOUNT,2), SUM(OMEGA.V_ADH_CETROOT_S.LOCAL_NOR) AS DrawSum, OMEGA.V_ADH_CETROOT_S.LOCAL_ORDER_TOTAL_AMT, getlevel1chair(@variable('RootChair')) Country_nameFROM OMEGA.V_ADH_CETROOT_SWHERE ( OMEGA.V_ADH_CETROOT_S.BOUID=' ' ) AND OMEGA.V_ADH_CETROOT_S.ABS_MONTH BETWEEN @prompt('FromMonth',D',,,) AND @prompt('ToMonth',D',,,) AND OMEGA.V_ADH_CETROOT_S.ROOT_CHAIR = @ Prompt ('RootChair') AND OMEGA.V_ADH_CETROOT_S.ORDER_REVISION_NUMBER = 'N' AND sigma_boss_canned_security(@Prompt('secret','A',,mono,)) = 1GROUP BY OMEGA.V_ADH_CETROOT_S.ABS_MONTH, OMEGA.V_ADH_CETROOT_S.EMPLOYEE_ID, OMEGA.V_ADH_CETROOT_S.OWNER_CHAIR_ID, OMEGA.V_ADH_CETROOT_S.CHAIR_NAME, OMEGA.V_ADH_CETROOT_S.COUNTRY_MCODE, OMEGA.V_ADH_CETROOT_S.SOURCE_TRANSACTION_CID, OMEGA.V_ADH_CETROOT_S.ORDER_REVISION_NUMBER, OMEGA.V_ADH_CETROOT_S.REVENUE_DATE, OMEGA.V_ADH_CETROOT_S.CUSTOMER_POSTAL_MCODE, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_NAME, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_CID, OMEGA.V_ADH_CETROOT_S.PRODUCT_CID_07, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_11, OMEGA.V_ADH_CETROOT_S.PARTNER_NAME, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_07, OMEGA.V_ADH_CETROOT_S.ORDER_DATE, OMEGA.V_ADH_CETROOT_S.CUSTOMER_PURCHASE_ORDER_CID, round(OMEGA.V_ADH_CETROOT_S.NET_AMOUNT,2), OMEGA.V_ADH_CETROOT_S.LOCAL_ORDER_TOTAL_AMT, getlevel1chair(@variable('RootChair')) Thanks anil |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-09 : 03:52:21
|
quote: Originally posted by anil2007 Hi all,i am working on data warehousing and creating derived tables with sql.... I am geting error like this Each Calculated column must have an explicit name Can you please help me on thisSELECT OMEGA.V_ADH_CETROOT_S.ABS_MONTH, OMEGA.V_ADH_CETROOT_S.EMPLOYEE_ID, OMEGA.V_ADH_CETROOT_S.OWNER_CHAIR_ID, OMEGA.V_ADH_CETROOT_S.CHAIR_NAME, OMEGA.V_ADH_CETROOT_S.COUNTRY_MCODE, OMEGA.V_ADH_CETROOT_S.SOURCE_TRANSACTION_CID, OMEGA.V_ADH_CETROOT_S.ORDER_REVISION_NUMBER, substr(OMEGA.V_ADH_CETROOT_S.REVENUE_DATE,1,10) Revenuedate, OMEGA.V_ADH_CETROOT_S.CUSTOMER_POSTAL_MCODE, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_NAME, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_CID, OMEGA.V_ADH_CETROOT_S.PRODUCT_CID_07, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_11, OMEGA.V_ADH_CETROOT_S.PARTNER_NAME, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_07, OMEGA.V_ADH_CETROOT_S.ORDER_DATE, OMEGA.V_ADH_CETROOT_S.CUSTOMER_PURCHASE_ORDER_CID, round(OMEGA.V_ADH_CETROOT_S.NET_AMOUNT,2), SUM(OMEGA.V_ADH_CETROOT_S.LOCAL_NOR) AS DrawSum, OMEGA.V_ADH_CETROOT_S.LOCAL_ORDER_TOTAL_AMT, getlevel1chair(@variable('RootChair')) Country_nameFROM OMEGA.V_ADH_CETROOT_SWHERE ( OMEGA.V_ADH_CETROOT_S.BOUID=' ' ) AND OMEGA.V_ADH_CETROOT_S.ABS_MONTH BETWEEN @prompt('FromMonth',D',,,) AND @prompt('ToMonth',D',,,) AND OMEGA.V_ADH_CETROOT_S.ROOT_CHAIR = @ Prompt ('RootChair') AND OMEGA.V_ADH_CETROOT_S.ORDER_REVISION_NUMBER = 'N' AND sigma_boss_canned_security(@Prompt('secret','A',,mono,)) = 1GROUP BY OMEGA.V_ADH_CETROOT_S.ABS_MONTH, OMEGA.V_ADH_CETROOT_S.EMPLOYEE_ID, OMEGA.V_ADH_CETROOT_S.OWNER_CHAIR_ID, OMEGA.V_ADH_CETROOT_S.CHAIR_NAME, OMEGA.V_ADH_CETROOT_S.COUNTRY_MCODE, OMEGA.V_ADH_CETROOT_S.SOURCE_TRANSACTION_CID, OMEGA.V_ADH_CETROOT_S.ORDER_REVISION_NUMBER, OMEGA.V_ADH_CETROOT_S.REVENUE_DATE, OMEGA.V_ADH_CETROOT_S.CUSTOMER_POSTAL_MCODE, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_NAME, OMEGA.V_ADH_CETROOT_S.END_USER_CUSTOMER_CID, OMEGA.V_ADH_CETROOT_S.PRODUCT_CID_07, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_11, OMEGA.V_ADH_CETROOT_S.PARTNER_NAME, OMEGA.V_ADH_CETROOT_S.CUSTOMER_CID_07, OMEGA.V_ADH_CETROOT_S.ORDER_DATE, OMEGA.V_ADH_CETROOT_S.CUSTOMER_PURCHASE_ORDER_CID, round(OMEGA.V_ADH_CETROOT_S.NET_AMOUNT,2), OMEGA.V_ADH_CETROOT_S.LOCAL_ORDER_TOTAL_AMT, getlevel1chair(@variable('RootChair')) Thanks anil
Try giving alias to the column in blue as well. Also its a good practise to give keyword AS before alias names. |
|
|
anil2007
Starting Member
5 Posts |
Posted - 2008-01-09 : 03:58:54
|
Hi visakh16i have tryed by giveing alias i am geting same errorThanksanil |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-09 : 04:06:53
|
Did you try executing functions seperately? Just to ensure, errors are not inside function like,getlevel1chair(@variable('RootChair')) |
|
|
anil2007
Starting Member
5 Posts |
Posted - 2008-01-09 : 04:13:53
|
Hi visakh16I have removed this function also but still i am geting same errorgetlevel1chair(@variable('RootChair')) Country_nameThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-09 : 04:21:03
|
Cant find anything else fishy here. But not sure what @prompt,@variable etc do here?? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-09 : 04:27:27
|
With the suggestion Visakh16 made - did you try " AS 'MyAlias' " -- or -- "AS MyAlias" , ?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-09 : 04:42:29
|
quote: Originally posted by anil2007 Hi visakh16i have tryed by giveing alias i am geting same errorThanksanil
Post the query you usedMadhivananFailing to plan is Planning to fail |
|
|
|
|
|