dbTalk Databases Forums  

Partition Data not shown

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Partition Data not shown in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Roedeske
 
Posts: n/a

Default Partition Data not shown - 05-03-2005 , 07:41 AM






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

Reply With Quote
  #2  
Old   
SQL McOLAP
 
Posts: n/a

Default RE: Partition Data not shown - 05-03-2005 , 10:29 AM






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:

Quote:
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

Reply With Quote
  #3  
Old   
Michael Roedeske
 
Posts: n/a

Default RE: Partition Data not shown - 06-02-2005 , 05:45 AM



Dear McOLAP,

we set a filter on the facts on months. I checked the meta data, everything
fine.
But this month we still had the same problem. After I set the filter manual
in the AS manager we got data, befor no data was shown. Any idea?

Thanks,
Michael
Quote:
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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.