Hi i have an app. that creates Partition using DSO on the app. i insert
the DimensionSlice (to update the time dimension) Custom property, when
i view the Partition using Analysis Manager every thing looks in place,
but when i process the partition the select that runs against the DB
doesn't include the dimension slice at the from and where of the select
clause.

I'm not sure why your SQL doesn't have the right filter once you set
the slice, but you can have your DSO code set the appropriate filter by
modifying the partition.SourceTableFilter property to ensure the SQL
will have it in the where clause.

When i set the Partition.SourceTableFilter the where clause is all
right, but the from clause still lacks the the dimension source table.
any suggestions ?

I won't claim to be an expert, but I have also recently created an
application that automatically generates partitions for me. I create
either a) a partition based on a where clause (set by setting the
SourceTableFilter on the clsPartitionDimension class), or b) by
establishing a slice by setting SliceValue on the clsPartitionLevel
class? You must then do a partion Update(), otherwise you will not see
the slice. In my experience, before I put in the Update(), I saw the
creation of the partitions, but as you described, I didn't see all the
setting I set. Hope that helps.

I won't claim to be an expert, but I have also recently created an
application that automatically generates partitions for me. I create
either a) a partition based on a where clause (set by setting the
SourceTableFilter on the clsPartitionDimension class), or b) by
establishing a slice by setting SliceValue on the clsPartitionLevel
class? You must then do a partion Update(), otherwise you will not see
the slice. In my experience, before I put in the Update(), I saw the
creation of the partitions, but as you described, I didn't see all the
setting I set. Hope that helps.

Setting slice is kind of tricky. You have to set SliceValue property for the
level (where applied) and above.
The customProperty of DimensionSlice is just for display only in the
partition wizard, has no effect on the real slice.

"gad (AT) datacube (DOT) co.il" wrote: