Data region in RS allows only 1 data source - virtual cube solutions?

I have a report requiring two different data sources be compared in one
data region. For example, I'm comparing a measure for a client against
a national average. The client measure comes from one cube and the
national average is stored in a sql database. RS won't allow two data
sources to be used in a data region unless you can use an aggregate
function on the second data source. I attempted to solve this by
creating a cube for the second data source (national averages) and then
a virtual cube to make one data source (i.e. one MDX statement from the
virtual cube per data region) for RS. The orginal MDX used for the
first data source required slicing by dimensions not included in the
national average cube and visa versa. I have been able to get the
correct answer for each cube before combining into the virtual cube,
but I can not get the measures correctly in the virtual if, for each
measure, I need to slice by a dimension that is not shared. I haven't
been able to find the information anywhere (and I've tried internet and
2 books), but because my measures are not correct I assume that a
virtual cube in only useful if the correct results are obtained by
slicing into only the shared dimensions? Are there any other solutions
to the rediculous RS limitation of only being able to provide one data
source to a data region? What we they thinking'oops, should have used spell check before submitting. it is a
ridiculous RS limitation.|||Hi Carrie,
I believe you can refer to more than one datasource from a data region such
as a table. Try putting in two data sources on a report and drag data from
them both into a table (note, you have to set the tables data source to one
data set).
see how that goes
<cwilliams@.choosehmc.com> wrote in message
news:1104767162.584780.225260@.z14g2000cwz.googlegroups.com...
> I have a report requiring two different data sources be compared in one
> data region. For example, I'm comparing a measure for a client against
> a national average. The client measure comes from one cube and the
> national average is stored in a sql database. RS won't allow two data
> sources to be used in a data region unless you can use an aggregate
> function on the second data source. I attempted to solve this by
> creating a cube for the second data source (national averages) and then
> a virtual cube to make one data source (i.e. one MDX statement from the
> virtual cube per data region) for RS. The orginal MDX used for the
> first data source required slicing by dimensions not included in the
> national average cube and visa versa. I have been able to get the
> correct answer for each cube before combining into the virtual cube,
> but I can not get the measures correctly in the virtual if, for each
> measure, I need to slice by a dimension that is not shared. I haven't
> been able to find the information anywhere (and I've tried internet and
> 2 books), but because my measures are not correct I assume that a
> virtual cube in only useful if the correct results are obtained by
> slicing into only the shared dimensions? Are there any other solutions
> to the rediculous RS limitation of only being able to provide one data
> source to a data region? What we they thinking'
>|||The answer is to create a calculated member using the ValidMeasure
function for each measure in the virtual cube. Just in case anyone is
interested...sql

Data Mirroring Vs. Log Shipping Vs. Replication

Hi everyboby,

Can anybody tell me the differences, advantages and disadvantages between these three solutions? When do I may use one or another?
Could you recommend me any documentation?

Thanks a lot,

Radamante71.

This article should get you started.

http://msdn2.microsoft.com/en-us/library/ms190202.aspx

Regards,

Gary

|||This white paper (http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx#EVKAG) also has a section that compares different high availability options in SQL 2005.

Data formatting problem

Hello,

I'm looking for solutions to a formatting problem.

I have two stand alone textboxes on a report body that I would like to have display side by side with very little white space between them.

Example: TextBox 1 contents (variable length) = "Muddy Waters"

Textbox 2 contents (variable length) = "B.Sc"

Current display:Muddy WatersB.Sc

Desired display:Muddy Waters B.Sc

Here is my problem.

Simple concatenation of values into 1 textbox would work if the font size and font family were the same for both textboxes; unfortunately this isn't the case. The font size and family for each textbox is different. Is there a richtext control I can place on the report and load with preformatted rich text?

Any suggestions would be appreciated.

Thanks,

Roy M

Hi,

Try making the first textbox right-aligned & the second textbox left-aligned. It might possibly solve your problem.

Just an idea

-Aayush

|||

1.Put both of the textboxes adjacent to each other .

2.Apply Font size and style.

3.Use Padding left for the second text box.

Hope this will solve your problem.

|||Thanks, but this won't work as I need to keep things left aligned.|||

Do they have to be separate textboxes? The easiest thing would be to replace the two with a single one, replacing the content with the values from both fields as follows:

Code Snippet

=Fields!Field1.Value & " " & Fields!Field2.Value

If your textboxes are in a table, select them both and right click for the context menu and choose 'Merge Cells' and do the same.

Good luck,

Larry|||

This won't work as the text formatting for both fields needs to be different.

Thanks anyway.

Data formatting problem

Hello,

I'm looking for solutions to a formatting problem.

I have two stand alone textboxes on a report body that I would like to have display side by side with very little white space between them.

Example: TextBox 1 contents (variable length) = "Muddy Waters"

Textbox 2 contents (variable length) = "B.Sc"

Current display:Muddy WatersB.Sc

Desired display:Muddy Waters B.Sc

Here is my problem.

Simple concatenation of values into 1 textbox would work if the font size and font family were the same for both textboxes; unfortunately this isn't the case. The font size and family for each textbox is different. Is there a richtext control I can place on the report and load with preformatted rich text?

Any suggestions would be appreciated.

Thanks,

Roy M

Hi,

Try making the first textbox right-aligned & the second textbox left-aligned. It might possibly solve your problem.

Just an idea

-Aayush

|||

1.Put both of the textboxes adjacent to each other .

2.Apply Font size and style.

3.Use Padding left for the second text box.

Hope this will solve your problem.

|||Thanks, but this won't work as I need to keep things left aligned.|||

Do they have to be separate textboxes? The easiest thing would be to replace the two with a single one, replacing the content with the values from both fields as follows:

Code Snippet

=Fields!Field1.Value & " " & Fields!Field2.Value

If your textboxes are in a table, select them both and right click for the context menu and choose 'Merge Cells' and do the same.

Good luck,

Larry|||

This won't work as the text formatting for both fields needs to be different.

Thanks anyway.