Post reply

editing where clause of the cube processing?

  • November 17, 2006 at 5:33 am

    #117626

    my cube fails when processsing. on looking at the sql that is causing the error ( obtained from the processing window) i can see the issue. it is using a table in the where clause that is not mentioned anywhere else in the query. where can i edit this sql or how can i edit it?The code is below, and the error causing part is shown in green text

     

    SELECT

    [dbo_PrintFactData].[Total] AS [dbo_PrintFactDataTotal0_0],[dbo_PrintFactData].[InvoiceVolume] AS [dbo_PrintFactDataInvoiceVolume0_1],

    [dbo_PrintFactData].[CountryDimensionID] AS [dbo_PrintFactDataCountryDimensionID0_2],

    [dbo_PrintFactData].[CurrencyDimensionID] AS [dbo_PrintFactDataCurrencyDimensionID0_3],

    [dbo_PrintFactData].[CustomerDimensionID] AS [dbo_PrintFactDataCustomerDimensionID0_4],

    [dbo_PrintFactData].[EngagementNameDimensionID] AS [dbo_PrintFactDataEngagementNameDimensionID0_5],

    [dbo_PrintFactData].[InvoiceNumberDimensionID] AS [dbo_PrintFactDataInvoiceNumberDimensionID0_6],

    [dbo_PrintFactData].[PONumberDimensionID] AS [dbo_PrintFactDataPONumberDimensionID0_7],

    [dbo_PrintFactData].[ReportDimensionID] AS [dbo_PrintFactDataReportDimensionID0_8],

    [dbo_PrintFactData].[SAPMessageDimensionID] AS [dbo_PrintFactDataSAPMessageDimensionID0_9],

    [dbo_PrintFactData].[SystemTypeDimensionID] AS [dbo_PrintFactDataSystemTypeDimensionID0_10],

    [dbo_PrintFactData].[TransactionDateDimensionID] AS [dbo_PrintFactDataTransactionDateDimensionID0_11],

    [dbo_PrintFactData].[CaseDimensionID] AS [dbo_PrintFactDataCaseDimensionID0_12],

    [dbo_PrintFactData].[ContractDimensionID] AS [dbo_PrintFactDataContractDimensionID0_13],

    [dbo_PrintFactData].[ResolutionTypeDimensionID] AS [dbo_PrintFactDataResolutionTypeDimensionID0_14]

    FROM

    (

    SELECT

    "Total", "InvoiceVolume", "CountryDimensionID", "ResolutionTypeDimensionID", "ContractDimensionID", "CaseDimensionID",

    "TransactionDateDimensionID", "SystemTypeDimensionID", "SAPMessageDimensionID", "ReportDimensionID", "PONumberDimensionID",

    "InvoiceNumberDimensionID", "EngagementNameDimensionID", "CustomerDimensionID", "CurrencyDimensionID"

    FROM

    "dbo"."PrintFactData" WHERE "PrintDimensionTransactionDate"."TransactionDate" >= '1/1/2004'  ------problem here, as PrintDimensionTransactionDate table is not mentioned previously in the table

    )

    AS

    [dbo_PrintFactData]

  • November 17, 2006 at 8:42 am

    #672641

    Select the Print cube in Solution Explorer.  Then click on the Partitions tab, then click in the source cell, from there you should be able to modify the query for the partition.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply