Re: Aggregate a dimension using DSO?

#1

If you want to force aggregations on specific dimensions see the topics Matt
described below. In addition, there are at least a couple of different
tools avaialable that will help you do this. One is the Partition
Aggregation Utility which you can download for free by downloading the SQL
Server Accelerator for Business Intelligence. You can download that at
www.microsoft.com/solutions/bi. The tool installs into the "tools"
directory (and you'll have to go to the tools directory to get it).

Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Matt Carroll [MS]" <MattCar (AT) online (DOT) microsoft.com> wrote

Quote:

Some topics that may be of interst to you available in the index of books
online:
Usage-Based Optimization Wizard
AggregationUsage property
ParitionAnalyzer object - DSO
Aggregation object - DSO

I suspect the Usage-Based Optimization Wizard may solve your problem, so
I'd
start with that. If that doesn't work, you can dig deeper eventually
getting to manually creating aggregations in DSO.

Hope this helps,
- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote in message
news:%23IBVKX$VDHA.2544 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi:

Using DSO, how to force Analysis Services to aggregate on a perticular
dimension? I have a feeling that some dimensions are not aggregated.

Thanks

#2

Thanks for the response. I really want to "manually creating aggregations in
DSO". Could you give me a short sample to do that in DSO? The thing I like
to know is how to create aggregation for a perticular dimension/level.

Thanks

"Matt Carroll [MS]" <MattCar (AT) online (DOT) microsoft.com> wrote

Quote:

Some topics that may be of interst to you available in the index of books
online:
Usage-Based Optimization Wizard
AggregationUsage property
ParitionAnalyzer object - DSO
Aggregation object - DSO

I suspect the Usage-Based Optimization Wizard may solve your problem, so
I'd
start with that. If that doesn't work, you can dig deeper eventually
getting to manually creating aggregations in DSO.

Hope this helps,
- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote in message
news:%23IBVKX$VDHA.2544 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi:

Using DSO, how to force Analysis Services to aggregate on a perticular
dimension? I have a feeling that some dimensions are not aggregated.

Thanks

#3

If you download the tool I mentioned in the previous response, you'll have
plenty of DSO code to go through in regards to aggregations. The source
ships with it.

Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote

Quote:

Thanks for the response. I really want to "manually creating aggregations
in
DSO". Could you give me a short sample to do that in DSO? The thing I like
to know is how to create aggregation for a perticular dimension/level.

Thanks

"Matt Carroll [MS]" <MattCar (AT) online (DOT) microsoft.com> wrote in message
news:eQeDD0DWDHA.2272 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Some topics that may be of interst to you available in the index of
books
online:
Usage-Based Optimization Wizard
AggregationUsage property
ParitionAnalyzer object - DSO
Aggregation object - DSO

I suspect the Usage-Based Optimization Wizard may solve your problem, so
I'd
start with that. If that doesn't work, you can dig deeper eventually
getting to manually creating aggregations in DSO.

Hope this helps,
- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Polaris" <etpolaris (AT) hotmail (DOT) com> wrote in message
news:%23IBVKX$VDHA.2544 (AT) tk2msftngp13 (DOT) phx.gbl...
Hi:

Using DSO, how to force Analysis Services to aggregate on a perticular
dimension? I have a feeling that some dimensions are not aggregated.

Thanks

#4

I read this post as I want to also find DSO code to create aggregations.
I tried to install the Accelarator but it needs a Enterprise Edition for
SQL Server and certain version of excel.

Can some one just email (ac_786 (AT) yahoo (DOT) com) me a sample VB app or sample
code that would allow me to specify the level for each dimension for
which I want to create an aggregation.

I intend to decide the levels that are crucial and then run different
loops (for various dims) and create several hundred aggregations.

Thanks,
Amir

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Aggregate a dimension using DSO?

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

Re: Aggregate a dimension using DSO? - 08-01-2003 , 02:28 PM

Re: Aggregate a dimension using DSO? - 08-01-2003 , 03:49 PM

Re: Aggregate a dimension using DSO? - 08-01-2003 , 07:59 PM

Re: Aggregate a dimension using DSO? - 12-05-2003 , 08:41 AM