Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2011-04-24 : 00:45:01
|
| hello all.this is part of my view :select CAST(ISNULL(dbo.TBL_Bank.TBL_BankTitle; '') + ISNULL(dbo.TBL_Customer.TBL_CustomerTitle; '') + ISNULL(dbo.WOS_WorkOrder.WOS_WoTitle; '') + ISNULL(dbo.BUD_Project.BUD_ProjectName; '') AS Nvarchar(200))as TamrkozName ,CAST(ISNULL(dbo.TBL_CustomerAccount.TBL_CaCode; 0) AS bigint) + CAST(dbo.CNT_Contract.CNT_ContractCode AS bigint) as SubTamrkozCode,CAST(ISNULL(LTRIM(RTRIM(dbo.TBL_CustomerAccount.TBL_CaTitle)); '') + ' ' + ISNULL(LTRIM(RTRIM(dbo.CNT_Contract.CNT_ContractTitle)); '') AS Nvarchar(200)) as SubTamrkozName,TBL_Bank.TBL_BankID + dbo.TBL_Customer.TBL_CustomerID + dbo.WOS_WorkOrder.WOS_WoID + dbo.ACC_AccountingDocumentDetail.ASS_AssetID_fk + dbo.ACC_AccountingDocumentDetail.BUD_ProjectID_fk AS TamrkozCode FROM dbo.ACC_AccountingDocumentDetail INNER JOIN dbo.ACC_AccountingCode ON dbo.ACC_AccountingDocumentDetail.ACC_AcID_fk = dbo.ACC_AccountingCode.ACC_AcID INNER JOIN dbo.CHK_Check ON dbo.ACC_AccountingDocumentDetail.CHK_CheckID_fk = dbo.CHK_Check.CHK_CheckID INNER JOIN dbo.TBL_Customer ON dbo.ACC_AccountingDocumentDetail.TBL_CustomerID_fk = dbo.TBL_Customer.TBL_CustomerID INNER JOIN dbo.TBL_Bank ON dbo.ACC_AccountingDocumentDetail.TBL_BankID_fk = dbo.TBL_Bank.TBL_BankID INNER JOIN dbo.ACC_AccountingDocument ON dbo.ACC_AccountingDocumentDetail.ACC_AdID_fk = dbo.ACC_AccountingDocument.ACC_AdID INNER JOIN dbo.TBL_Form ON dbo.ACC_AccountingDocument.TBL_FormID_fk = dbo.TBL_Form.TBL_FormID INNER JOIN dbo.TBL_Resource ON dbo.ACC_AccountingDocument.TBL_ResourceID_fk = dbo.TBL_Resource.TBL_ResourceID INNER JOIN dbo.WOS_WorkOrder ON dbo.ACC_AccountingDocumentDetail.WOS_WoID_fk = dbo.WOS_WorkOrder.WOS_WoID i want to simulation TamrkozName ,subTamrkozName ,tamarkozecode.subtamarkozecode in my cube and by named calculation in data source view can not do this.how to do this?that can see tamarkozacod and etc in browser of my cube.lili@@ |
|
|
|
|
|
caculate member