Create a cube in analysis services out of more than one fact table.

Is it possible to create a cube in analysis services that has columns from
more than one fact table as long as the fact tables share the same data
grain and dimensions?
Thanks for any advice.
Regards,
Anthony
Hi Anthony,
In AS 2005, this is support via the UDM.
In AS 2000, create two Cubes (one from each fact table) then create a
virtual cube to link the two.
If the facts are at the same grain and have the same dimensions, consider
moving the measures into one fact table.
regards
Jamie
"anthony garcia" <acgarcia21@.verizon.net> wrote in message
news:ZISch.7793$Ga7.2309@.trnddc01...
> Is it possible to create a cube in analysis services that has columns from
> more than one fact table as long as the fact tables share the same data
> grain and dimensions?
> Thanks for any advice.
> Regards,
> Anthony
>

Create a cube in analysis services out of more than one fact table.

Is it possible to create a cube in analysis services that has columns from
more than one fact table as long as the fact tables share the same data
grain and dimensions?
Thanks for any advice.
Regards,
AnthonyHi Anthony,
In AS 2005, this is support via the UDM.
In AS 2000, create two Cubes (one from each fact table) then create a
virtual cube to link the two.
If the facts are at the same grain and have the same dimensions, consider
moving the measures into one fact table.
regards
Jamie
"anthony garcia" <acgarcia21@.verizon.net> wrote in message
news:ZISch.7793$Ga7.2309@.trnddc01...
> Is it possible to create a cube in analysis services that has columns from
> more than one fact table as long as the fact tables share the same data
> grain and dimensions?
> Thanks for any advice.
> Regards,
> Anthony
>

creat a solution in SQLServer 2005 and intall that solution in SQLServer 2005 Express

Hi,

can i develop a solution in SQLServer 2005 with the analysis Services (OLAP cubes) and then put that solution in a client that only have the SQLServer 2005 Express?

Thaks

Larokas

Analysis Services are not part of SQL Server 2005 Express installation.

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

cpu & memory usage on large, long-running query

Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
Loane
If you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:

>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>
|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>

cpu & memory usage on large, long-running query

Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
LoaneIf you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:

>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.
4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>
>

Couple of questions over SSRS over SSAS

I've created a sales analysis cube using SQL Server 2005 and want to do some reporting using SSRS. My problems are as follow:

1. How can I change the report parameter from a Date type into a member of the Date dimension? I need to do this because it's easier for business user to select the date and I can set a sensible default to it.

2. How can I create a hourly sales analysis report for all branches? If I add a chart into SSRS, I will get all shop data summing up right now into a single chart. Instead, I would like to have a chart for each branch. My business user will not accept to manually select different branch and generate the required chart.

3. How can I add a percentage to the corresponding value? My business user may want to view the sales performance during 1:00pm ~ 2:00pm comparing to the whole day. Moreover, they may also want to compare the sales on Monday to the sales for the whole week in percentage sense.

Thanks for any advise.

Regards,
AlexI've solved the third question. In order to do this, I need to add a new column to the matrix. After that, I put the following into expression of the new cell to calculate the percentage.

=Count(Fields!Sales_Count.Value)/Count(Fields!Sales_Count.Value, "matrix1_Day")

matrix1_Day is the column group name that I found out by right click and select the "Edit Group".

This solution is available in the book Microsoft SQL Server 2005 Reporting Services by McGrawHill pp.327-331.

Hope this can help someone later on.

Regards,
Alex