Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Shamli

  1. Shamli

    Rule for Partition

    We have INDEX on field used to filter partition. Our historic data also get UPDATED daily so we are doing "FULL PROCESS" daily. Question1: Is there any better option other than "FULL Procss" considering the fact our historic data get UPDATED daily. According my understanding INCREAMENTAL...
  2. Shamli

    Rule for Partition

    What is your cube partinioned on? Cube is partitioned on date, for example Partition1: Most recent 200 dates Partition2: Most recent 201 to 300 dates Partition3: Older than Most recent 300 dates. How it works: During warehouse load we update a field called [DaysDiff From IsRecent] which has...
  3. Shamli

    Rule for Partition

    I mentioned all MEASURES are RELATED so it may not make sense to break Fact table but still if breaking Fact Table may help than we can consider that too. I have partition on base of date whcih is working fine. I want to optimize our environemnt and trying to figure out if we can do somthing...
  4. Shamli

    Rule for Partition

    Corection Our Fact table has 200 measures not 100 and all are related.
  5. Shamli

    Rule for Partition

    Hi All, We have 6 Mln rows in Fact table with 100+ measures. As of now we have 3 partitions with following config Part1 : 1,834,099 with 0%Aggregation MOLAP Part2 : 3,092,143 with 30%Aggregation MOLAP Part3 : 1,105,211 with 30%Aggregation MOLAP We are using SQL Analysis Service 2005 on...
See more

Part and Inventory Search

Back
Top