You're welcome

There are 2 options when creating a range.

1. Create a table in your DW to store the range. This approach very usefull when you have a dynamic range. Change...

You're welcome

I'm going to choose AMO. See the sample code in http://www.codeplex.com

I guess you can't add dimension without having full process the cube. Everytime you change the structure, you must full process the cube

I've been hearing this stetement so many times. MS got a first class quality OLAP and ETL for BI (see http://www.olapreport for market share data), but lack of...

Based on my experiances, when we start a package, SQL Server start populating memory with the data needed by the package. So it's really worth to reduce the size of...

Cris E (8/19/2009)

---

There's usually a right way, but sometimes there's a simple way too. This sounds more like a reporting problem than an analysis problem, so keep it basic. Consider...

For books, you can start with Step By Step series by Microsoft.

For online resource ... try this one

http://sqlserver2008jumpstart.microsofttraining.com/

First ... I guess you get the wrong idea about Business Intelligence/Data Warehouse (BI/DW). BI/DW is not an operational tools that could change dynamically, but an analysis tools. This means...

If you need a zero cost solution, try to check AMO, an API used to access SSAS. Dundas built on top of this API

Here what I would do

1. Create a fact table to store count and avg record length for each table (see BOL to get the exact formula) - with 2 dimension:...

Create a new SSIS package using BIDS, use Analysis Services Processing Task. Set the properties, and choose Incremental Update in Processing Setting option

Hi,

I guess you want to display a price per month.

Try this one. Open you SSAS solution, click your cube, and click your Price measure, and view the properties...

Hi Rayash,

Before you begin to load your fact table into data warehouse, I guess you must load the dimension table first. Do you used a surrogate key in your dimension...