Matrix Report and its column aggregates

hello everyone,
We have the following scenario, and are struggling to get an efficient
way of doing this...
We have a matrix report that looks something like this
_______________________
| | Column Header |
---
| | Sub Col1 |Sub Col2|
---
| Date | Value Value |
---
We have to evaluate a number of additional attributes - like mean, std
Deviation,max value, min value, etc for each of the columns (the total
sub columns can vary between 1 and 9).
this additional info has to be shown in a seperate table/matrix -
|Statistics |Sub Col1|Sub Col2|
---
|Mean | 1.5 | 2.5 |
---
|S.Deviation | 0.5 | 1.5 |
---
|Max Value | 3.5 | 4.5 |
---
i know that aggregate functions are available to get this info, i am
just not sure how i can show this in the second matrix. Also i want to
avoid calling the stored proc twice as this might slow down the report
(the number of rows can be around 5000).
Any suggestion that would lead to an optimum solution will be swell...On Nov 27, 7:17 pm, Sid <sid.pras...@.gmail.com> wrote:
> hello everyone,
> We have the following scenario, and are struggling to get an efficient
> way of doing this...
> We have a matrix report that looks something like this
> _______________________
> | | Column Header |
> ---
> | | Sub Col1 |Sub Col2|
> ---
> | Date | Value Value |
> ---
> We have to evaluate a number of additional attributes - like mean, std
> Deviation,max value, min value, etc for each of the columns (the total
> sub columns can vary between 1 and 9).
> this additional info has to be shown in a seperate table/matrix -
> |Statistics |Sub Col1|Sub Col2|
> ---
> |Mean | 1.5 | 2.5 |
> ---
> |S.Deviation | 0.5 | 1.5 |
> ---
> |Max Value | 3.5 | 4.5 |
> ---
> i know that aggregate functions are available to get this info, i am
> just not sure how i can show this in the second matrix. Also i want to
> avoid calling the stored proc twice as this might slow down the report
> (the number of rows can be around 5000).
> Any suggestion that would lead to an optimum solution will be swell...
Any suggestions from the experts?

master/Child Deployment

Hi Guru's,

I am facing a problem in deploying the SSIS packages.

My Scenario is like this

1. Have one Master SSIS Package.

2. Master SSIS Package inturn calls 3 Different packages using execute package task.

3. I have a common Configuration file for all these packages.

4. I am using File System deployment.

5. I have imported all the packages i.e master and the 3 child packages using SQL Server management studio.

6. Now i have created a job, and added the master package as a step.

7. I have a variable declared in the configuration file and the child packages will be getting their path from this variable.

The problem since i know the imported packages lies in "C:\Program Files\Microsoft SQL Server\90\DTS\Packages\<<Folder Name>>" i have poited the child package variable to point to this directory.

I still want to import all the packages and want to get this directory info dynamically thorugh the script so that i can assign this at run time.

I am using "Directory.GetCurrentDirectory" But it's giving me a different location when we run the master package.

Can any one has any idea or comments how to retrive the path of the master package?

Even a work around or any other option is also fine....

Regads,

Dev

I may not be clear on your requirements, but here's what I do:

I have a configuration file that is used by all packages, for database connections and whatnot, and a I have one that is specifically for the master. If any of the child packages need anything from the master configuration file, the master package will pass the information down to them.

The master has a variable named ChildPackagePath which is the folder location of the child packages. This variable is set by the master's configuration file. I then use expressions on the connection managers to the child packages to set the Connection String property as @.ChildPackagePath + "packagname.dtsx".

This allows you to vary the location of the child packages by the server environment. I don't think that determining the package location dynamically at runtime is possible. Your best bet is to use a path defined in a configuration file, or use a path that is dynamically available in an environment variable such as USERPROFILE.