.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

guide lines for implementing very large cube

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server

Hey eb

I am in the process of designing a daily partitioned cube where each

partition should hold some half a milion records.

Cube also contain some 12 dimensions and that number may grow.

Are you aware of any guidelines i should follow to ensure cube is

stable and efficient?

I am using 32bit 2003 sp2 server with 32 GB RAM.

SSAS 2005 sp3.

I have already trouble processing (incrementaly) another smaller daily cube.

How can i allow ssas consume more RAM then its default settings?

As for quries perforemance are there any guidelines on top of

fine tuning aggregations usage and upgrading server to 64bit?

Thanks alot!


View Complete Post

More Related Resource Links

Cube Writeback with weighted allocation working strangely - creating large negative values against f




I've got a cube (2008) with 2 MGs: Actuals and Budgets.

The Budgets partition is Write-Enabled.


On Excel 2010 the user will select the Actual Date for 2010-07, and will set the Budget date to 2011.

After seeing what the YTD actual figure looks like he enters the budget for 2011.

It is supposed to take that budget figure and split it between the funds that have actuals against them (using weighting).


Here's the problem:


SSAS allocates inflated figures against those funds, and then, so that the sum of those values will equal the originally entered amount, it puts a large negative value against the first Member in the fund dimension (I experimented with this by deleting the first member in that dimension. It just allocates the negative value against the new member!).

Why isn't it just allocating the values based on the ratio that it gets from that Actuals calc?



The UPDATE statement on the trace looked like this:


UPDATE CUBE [Forecasting]
SET  (
        [Actuals Date].[Year-Quarter-Month-Day Hierarchy].[Calendar Year Month].&[2010-07]
        , [Budget Date].[Year-Quarter-Month-Day Hierarchy].[Calendar Year].&[2011]

LINQ : Implementing IN and NOT IN

I got tried of typing

var result = from s in source
where items.Contains(s)
select s;and so I implemented the IN and NOT IN methods as extension methods:

Implementing Continuous Scrolling UI Pattern in ASP.NET

When you have numerous records to show, we have to resort to Paging. There is a better alternative to display voluminous data (especially read only data) while providing a better user experience & also making efficient use of server bandwidth - the Continuous Scrolling or Infinite Scrolling UI Pattern. Read on to know more about how to implement Continuous Scrolling UI Pattern in ASP.NET with a GridView.

Microsoft SharePoint Online Standard Developer Guide

Developers Guide for SharePoint Online (Standard Offer). Microsoft® Office SharePoint® Online is a collection of Web-based tools and technologies built on Microsoft Office SharePoint Server 2007 that help you store, share, and manage digital information within your company. This white paper describes the customization (or extensibility) capabilities that are supported with the Standard offering of SharePoint Online

Draw lines excactly on physical device pixels

When you draw a line in WPF you will experience that they often appear blurry. The reason for this is the antialiasing system that spreads the line over multiple pixels if it doesn't align with physical device pixels.

Bluetooth Printing Guide using Windows Mobile Pocket Pc

FieldSoftware Products printing products use the Bluetooth "Serial Port Profile" (SPP). Unfortunately, there is no standard method to find your Bluetooth printer and begin printing... each device contains a Bluetooth stack/driver that determines the steps. There are two main stacks currently available... one from Microsoft and one from WIDCOMM/Broadcom. Below are step-by-step instructions for printing with the Microsoft and WIDCOMM stacks. Note that these may change for different versions of the Bluetooth stacks or for different manufacturers. Consult the documentation for your device for specific details on your device.

Identifying your device''s Bluetooth stack: There is no sure steps to identify a Bluetooth stack on a device. Below are steps for identifying current WIDCOMM and Microsoft stacks at the time this page is published. Note that these may not identify earlier or later versions of the same BT stacks.

Enterprize library 4.1 getting output parameter after adding record in db, plz guide



I need to get output parameter (flag) from db after saving record in database. I am using Microsoft Enterprise Library 4.1 for DB. I am inserting record using I Data reader.

Please guide


Persist large dataset across ASP.NET pages. No database


Can anyone give me suggestions on how to implement the following requirement?

1. A online wizard (step-by step operation) processes user requests across several ASP.NET pages.  The session data is stored in memory until the user submits the request.  Once the request is submitted, a XML file is created and the data are passed to XML.

# Case Study: The parent page has a "select" button.  Click "select" will pop up a child page.  The users can select 1000+ items from a datagrid in the child page.  Once the user clicks "confirm", the selected items in the child page will be populated to the selected item gridveiw in the parent page.  The user can keep selecting more in the child page and the selected items will be appended to the gridview in the parent page.


- What's the best way to extract strings from a text file and convert to a dataset in memory and then present it in a datagrid in UI?

- What's the best way to persist and manipulate a large dataset across pages?  Session? or ViewState? Can it be accomplished by LINQ?

The app doesn't interact with a DB.  Once the request is submitted, it will convert the in memory data to a XML file.  What technology can be used to accomplished this?&nb

I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary


I want Er Diagram for Fees System of small institution ,can u plz guide me what fields are necessary to store Fees information ...


How to generate large pdf's?


Hi all,

I am using rdlc reports in my appln. Am trying to generate a huge pdf file which almost consists of 1500 - 2000 pages.
I have used ReportViewer and am adding datasource (Generic collection) to report. But am getting system out of Memory exception as it is a huge file.
Can any one suggest me how to generate large pdf files in asp.net c#

Lessons Learned: Optimizing A Large Scale Software + Services Application


Udi Dahan explains how his team identified and overcame unforeseen problems while developing a large-scale software + services trading application.

Udi Dahan

MSDN Magazine April 2009

CLR Inside Out: Large Object Heap Uncovered


This month CLR Inside Out reveals the secrets behind the Large Object Heap-what's there, when it's released, how the garbage collector handles the objects there.

Maoni Stephens

MSDN Magazine June 2008

Editor's Note: A Large Release Wave is Headed your Way


This month Howard Dierking discusses the coverage of Windows Server 2008, SQL Server 2008, and Visual Studio 2008.

Howard Dierking

MSDN Magazine Launch 2008

Secure By Design: Your Field Guide To Designing Security Into Networking Protocols


If you were to build a new communications protocol from scratch, how would you address security? Here the authors take a look at that question and generate some valuable insights into secure protocols.

Mark Novak and Andrew Roths

MSDN Magazine September 2006

Security Briefs: Step-by-Step Guide to InfoCard


In my April 2006 column I began a discussion of InfoCard, the upcoming identity metasystem, which is being prepared for release in the Windows VistaT timeframe. If you haven't read that column, you should definitely start there because I'm going to assume you're familiar with the basics I covered.

Keith Brown

MSDN Magazine May 2006

Data Points: Using XQuery, New Large DataTypes, and More


SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.

John Papa

MSDN Magazine March 2006

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend