RE: Partition Data not shown
- From: "SQL McOLAP" <SQLMcOLAP@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 May 2005 08:29:11 -0700
If data doesn't show after processing, then your slices are set incorrectly,
or not at all. From a high level, it sounds like your DSO has a bug and
isn't properly setting the slices, or setting the filter (if your setting a
filter on your fact table /view, instead of having seperate tables/views for
each partition).
Check the slice info in your metatdata after your DSO code runs. If it's
not correct, your DSO code has problems. If it's OK, make sure it matches
the source filter of the partition, if you're using source filtering.
Good luck.
"Michael Roedeske" wrote:
> Hello,
>
> we use partitioning, each partition holds data for a special month. The
> partitions are created automatically with dso. Now we expect sometimes (oh
> what nice) that some
> of the new created partitions do not show any data (not even in the data
> browser). Reprocessesing or changing the data storage doesnt make the data to
> appear. What
> helps, is to manually re-select the filter of the special month. Then after
> a reprocessing the data is shown.
>
> System: AS 2000 EE SP3a english, MOLAP Partitions
>
> Is there someone out who had this problem too? Is there maybe a workaround?
>
> Thanks,
> Michael Roedeske
.
- References:
- Partition Data not shown
- From: Michael Roedeske
- Partition Data not shown
- Prev by Date: Re: OLAP OLEDB Client Slow to Connect
- Next by Date: Number of cubes and processing time
- Previous by thread: Partition Data not shown
- Next by thread: drilltrough in excel2003
- Index(es):
Relevant Pages
|
