Showing posts with label usage. Show all posts
Showing posts with label usage. Show all posts

Wednesday, March 21, 2012

Export / Import Aggregations

Hello,

Is there a way to export / import the partition aggregations ?

The thing is - I ran the usage base optimization (+ using a bit of SP2 AggMgr.exe), but everytime I change the cube and redeploy, it overrides the aggregations and i have to rerun the usage base optimizer.

Thanks,

Haggai

What exactly do you intend import or export: aggregation design object or physical aggregation?

I don't know if there is a tool to export/import aggregations but if it exists I think it would be very dangerous because aggregations strictly depend from metadata.

When you say "everytime I change my cube" what does it means? Probably that something changed in your metadata so AS have to overrides aggregations.

Anyway like any other object aggregation can be defined using DDL so you can try to look at yours .partitions file.

|||

Good question.

I dont know of any automated tool or way of adding aggregation desing into a measure group. Though I can see someone enhancing AggregationManager sample application to allow for loading aggregation design stored in file. Or copying aggregation design from one measure group to another. I might have some time doing that :)

As for now, the easiest way would be to create a XMLA script of your old measure group and save only AggregationDesign object part of it in the separate file. Then create XMLA script of new measure group and add AggregationDesing object to it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Based on your answer - I Altered my new measure group and pasted the old AggregationDesigns object. It works fine.

Export / Import Aggregations

Hello,

Is there a way to export / import the partition aggregations ?

The thing is - I ran the usage base optimization (+ using a bit of SP2 AggMgr.exe), but everytime I change the cube and redeploy, it overrides the aggregations and i have to rerun the usage base optimizer.

Thanks,

Haggai

What exactly do you intend import or export: aggregation design object or physical aggregation?

I don't know if there is a tool to export/import aggregations but if it exists I think it would be very dangerous because aggregations strictly depend from metadata.

When you say "everytime I change my cube" what does it means? Probably that something changed in your metadata so AS have to overrides aggregations.

Anyway like any other object aggregation can be defined using DDL so you can try to look at yours .partitions file.

|||

Good question.

I dont know of any automated tool or way of adding aggregation desing into a measure group. Though I can see someone enhancing AggregationManager sample application to allow for loading aggregation design stored in file. Or copying aggregation design from one measure group to another. I might have some time doing that :)

As for now, the easiest way would be to create a XMLA script of your old measure group and save only AggregationDesign object part of it in the separate file. Then create XMLA script of new measure group and add AggregationDesing object to it.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Based on your answer - I Altered my new measure group and pasted the old AggregationDesigns object. It works fine.

Friday, March 9, 2012

Experiences in using SQL Server reporting services

Can any of you who have started or evaluated usage of SQL Server
reporting services please share your experiences.
How come there is still no thread on microsoft.public.sqlserver.* on
Reporting services will it be implemented at some stage.
Regards
SimonSimon,
> Can any of you who have started or evaluated usage of SQL Server
> reporting services please share your experiences.
> How come there is still no thread on microsoft.public.sqlserver.*
> on Reporting services will it be implemented at some stage.
Reporting Services is still in beta so people post their questions
on a dedicated beta newsgroup. I expect a Reporting Services
newsgroup will be added once the product is released.
Linda

Experiences in using SQL Server reporting services

Can any of you who have started or evaluated usage of SQL Server
reporting services please share your experiences.
How come there is still no thread on microsoft.public.sqlserver.* on
Reporting services will it be implemented at some stage.
Regards
SimonSimon,
quote:

> Can any of you who have started or evaluated usage of SQL Server
> reporting services please share your experiences.
> How come there is still no thread on microsoft.public.sqlserver.*
> on Reporting services will it be implemented at some stage.

Reporting Services is still in beta so people post their questions
on a dedicated beta newsgroup. I expect a Reporting Services
newsgroup will be added once the product is released.
Linda|||Hi,
Dont know if you have used crystal reports at all (Yeuch)
Butr grouping in sql server reporting is done with a table also matrix and l
ists.
The report produces xml ie RDL report definition language
Only thing ive found to date is you cant have subreports/data set data
in report header/footers which is a pain if you want a disclaimer sub report
included in the footer
Apart from that it looks cool