Urgent! Process partition fails when partition is cloned

Urgent! Process partition fails when partition is cloned

Post by Amirali Charani » Sat, 09 Mar 2002 01:59:15



I am trying to create a partition based on another
partition. Both the partitions have different fact tables.
But when I create the new partition and clone it to the
previous one, I am not able to process the new partition
because it gives me this error:

Statement(s) could not be prepared.;42000;The column
prefix 'dbo.VW_FC_STORE_INVENTORY_2001June' does not match
with a table name or alias name used in the
query.;42000;The column
prefix 'dbo.VW_FC_STORE_INVENTORY_2001June' does not match
with a table name or alias name used in the query.;42000;

This is because the partition is still using the name of
the previous partition (2001June). Where as it is supposed
to use the name of the current partition (2001August).

Note that I am setting the values of the foll. properties
for the current partition:

SourceTAble
SourceTableAlias
FromClause
JoinClause
SourceColumn for every measure in the partition

All of the above properties have been set to the current
table. My fact table name (or source table is correct).
Its just that the SELECT statement used to process the
partition still contains the name of the previous table in
some columns.

Below is the SELECT clause that the system uses for
processing the partition. Note that it uses the correct
table alias for some columns and not for the others.

Any help would be greatly appreciated.
Amir

Partition 'Store POS_2001August_1' Execute :

SELECT "dbo"."VW_FC_POS_2001June"."Dimension_1_WK",
"dbo"."VW_FC_POS_2001June"."Dimension_2_WK",
"dbo"."VW_FC_POS_2001June"."Dimension_3_WK",
"dbo"."VW_FC_POS_2001June"."Dimension_4_WK",
"dbo"."VW_FC_POS_2001June"."Dimension_4_WK",
"dbo"."VW_FC_POS_2001August"."Dimension_4_WK",
"dbo"."VW_FC_POS_2001August"."Dimension_4_WK",
"dbo"."VW_FC_POS_2001August"."Measure_1",
"dbo"."VW_FC_POS_2001August"."Measure_1",
"dbo"."VW_FC_POS_2001August"."Dimension_4_WK"
FROM
"dbo"."VW_FC_POS_2001August",
"dbo"."DI_Customer",
"dbo"."DI_Product"
WHERE
("dbo"."VW_FC_POS_2001June"."TXN_date_WK"=?) AND
("dbo"."VW_FC_POS_2001August"."Customer_WK"="dbo"."DI_Custo
mer"."Customer_WK") AND
("dbo"."VW_FC_POS_2001August"."Product_WK"="dbo"."DI_Produc
t"."Product_WK")
ORDER BY "dbo"."VW_FC_POS_2001August"."Dimension_4_WK"

 
 
 

Urgent! Process partition fails when partition is cloned

Post by Thierry Bacchett » Thu, 23 May 2002 22:44:50


The bad table alias is the source table of the cube.
These alias are used for each column corresponding to a
dimension.

The solution is to change the memberkey of the last level
for each dimension of the partition

After cloning the partition :

Dim dsoClonePartition As DSO.Partition
Dim dsoMeasure As DSO.Measure
Dim dsoDim As DSO.Dimension
Dim dsoLevel As DSO.Level

Set dsoClonePartition = dsoCube.MDStores.Item
(Partition_Name)
For Each dsoDim In dsoClonePartition.Dimensions
  Set dsoLevel = dsoDim.Levels(dsoDim.Levels.Count)
  dsoLevel.MemberKeyColumn = Replace(
dsoLevel.MemberKeyColumn, dsoCube.SourceTable,
dsoClonePartition.SourceTable)
Next
dsoClonePartition.Update    

Good Luck

Thierry

Quote:

>>-----Original Message-----
>>I am trying to create a partition based on another
>>partition. Both the partitions have different fact
>tables.
>>But when I create the new partition and clone it to the
>>previous one, I am not able to process the new partition
>>because it gives me this error:

>>Statement(s) could not be prepared.;42000;The column
>>prefix 'dbo.VW_FC_STORE_INVENTORY_2001June' does not
>match
>>with a table name or alias name used in the
>>query.;42000;The column
>>prefix 'dbo.VW_FC_STORE_INVENTORY_2001June' does not
>match
>>with a table name or alias name used in the query.;42000;

>>This is because the partition is still using the name of
>>the previous partition (2001June). Where as it is
>supposed
>>to use the name of the current partition (2001August).

>>Note that I am setting the values of the foll.
properties
>>for the current partition:

>>SourceTAble
>>SourceTableAlias
>>FromClause
>>JoinClause
>>SourceColumn for every measure in the partition

>>All of the above properties have been set to the current
>>table. My fact table name (or source table is correct).
>>Its just that the SELECT statement used to process the
>>partition still contains the name of the previous table
>in
>>some columns.

>>Below is the SELECT clause that the system uses for
>>processing the partition. Note that it uses the correct
>>table alias for some columns and not for the others.

>>Any help would be greatly appreciated.
>>Amir

>>Partition 'Store POS_2001August_1' Execute :

>>SELECT "dbo"."VW_FC_POS_2001June"."Dimension_1_WK",
>>"dbo"."VW_FC_POS_2001June"."Dimension_2_WK",
>>"dbo"."VW_FC_POS_2001June"."Dimension_3_WK",
>>"dbo"."VW_FC_POS_2001June"."Dimension_4_WK",
>>"dbo"."VW_FC_POS_2001June"."Dimension_4_WK",
>>"dbo"."VW_FC_POS_2001August"."Dimension_4_WK",
>>"dbo"."VW_FC_POS_2001August"."Dimension_4_WK",
>>"dbo"."VW_FC_POS_2001August"."Measure_1",
>>"dbo"."VW_FC_POS_2001August"."Measure_1",
>>"dbo"."VW_FC_POS_2001August"."Dimension_4_WK"
>>FROM
>>"dbo"."VW_FC_POS_2001August",
>>"dbo"."DI_Customer",
>>"dbo"."DI_Product"
>>WHERE
>>("dbo"."VW_FC_POS_2001June"."TXN_date_WK"=?) AND

("dbo"."VW_FC_POS_2001August"."Customer_WK"="dbo"."DI_Custo
Quote:>>mer"."Customer_WK") AND

("dbo"."VW_FC_POS_2001August"."Product_WK"="dbo"."DI_Produc

- Show quoted text -

Quote:>>t"."Product_WK")
>>ORDER BY "dbo"."VW_FC_POS_2001August"."Dimension_4_WK"

>>.

>.