DataSources

I have come into a company where my predesessor used a TON of differently
named RDS files to connect to the same SQL Server Database. My suspicion is
that he thought that datasources were the same as datasets and created one
for each.
Is there any good reason to do this?
Should they all have been changed to be something generic like
"ConnectTo{servername}Production.RDS (instead of {Report Name}.RDS)
Any thoughts?
Thanks,
KeithIm sure there are different schools of thought, but I enjoy using all the
same name and have never had reason to make them all different, nor have I
had any issues.
Michael C
"greenmtnsun" wrote:
> I have come into a company where my predesessor used a TON of differently
> named RDS files to connect to the same SQL Server Database. My suspicion is
> that he thought that datasources were the same as datasets and created one
> for each.
> Is there any good reason to do this?
> Should they all have been changed to be something generic like
> "ConnectTo{servername}Production.RDS (instead of {Report Name}.RDS)
> Any thoughts?
> Thanks,
> Keith
>
>sql

DataSource Renaming

How do you check to find a data source....We were testing a cube, decided that we wanted to change the names of the dimensions, datasources, etc.

I thought I had gone though each data source, dimension, data source view, that had a reference to datasource view "A" and changed it to reference "B". I did this by going into the view code and finding each reference to "A" and replacing it with "B". However, now when I try to process a dimension, I get the following error message:

The 'DataSourceView' with 'ID' = 'A' doesn't exist in the collection.

Well, I didn't want it to exist because I thought I had changed it to reference "B". Every time I try to go in to the view code section to see if I missed a reference to "A", it says that it can't find a "A".

I was just wondering if there is another way that I could go about finding if I have truly changed all references from "A" to "B"

Every object in SSAS has a name and ID propety. You can change the name freely, but the ID is not meant to be changed as the ID can be used all over the place internally.The Id's are unique within their object type, but not within the database, so doing a straight search and replace in the script can create problems.

If you haven't already tried this, Try connecting to the server, right clicking on the database and getting it to script the whole database as an alter script and then search through for datasource "A".

Datasource

How can I synchronize a table inside a list if both have different
datasources?
I need to synchronize the table by the list details grouping expression. If
I use the table filter, the table fieldID is always aggregated when inside
a list with a different datasource and it results in error.
and
if I add a field to a table from another datasource it is always in the form
Sum(Fields!Field.Value, "datasource")
which is the total sum of the values of the datasource even though the
datasource is grouped on the same field the table is grouped
how can I break this aggregate by the same field the table is grouped so
that I did not get the always the same total sum of all the values of that
aditional datasource in all rows of the table?
Thank you in advance
Martin Suchy
CBSolutionsWithin a data region you cannot use more than one dataset. You have to write
a single query that supplies data to the list and to the table. In most
cases, this involves a JOIN SQL query.
HTH
Charles Kangai, MCT, MCDBA
"Martin" wrote:
> How can I synchronize a table inside a list if both have different
> datasources?
> I need to synchronize the table by the list details grouping expression. If
> I use the table filter, the table fieldID is always aggregated when inside
> a list with a different datasource and it results in error.
> and
> if I add a field to a table from another datasource it is always in the form
> Sum(Fields!Field.Value, "datasource")
> which is the total sum of the values of the datasource even though the
> datasource is grouped on the same field the table is grouped
> how can I break this aggregate by the same field the table is grouped so
> that I did not get the always the same total sum of all the values of that
> aditional datasource in all rows of the table?
> Thank you in advance
> Martin Suchy
> CBSolutions

DataSet populated by multiple DataSources at once

Hi all,
I have seen this question asked many times, but never an answer posted.
Here is the situation: I need to connect dynamically to an unknown
number of databases at runtime, which the user will be no part of (any
parameters involving the Servers or DBs will be internal/hidden). The
data in each of these databases will then be consolidated and
represented in a single dataset. We are using SQL Server 2005.
Is there a way to use multiple datasources (i.e. get multiple tables
from separate databases/servers) and use them all in the same dataset
without using stored procedures? I know this can be done in Crystal,
but as yet there is no documentation on how to do this with SQL
Reporting Services. Are there any articles or examples out there of
this that do not involve consolidating the data into another database
first or using stored procedures?
Thanks!
Lance MOkay, through some "suggestiongs" this is what I have found out. There
are about 3 ways of dynamically creating this dataset (there are more
but these are the easiest and most useful ways), each of them trickier
than the last.
1)The first way is to use the SQL Server Linked Server feature. I was
told to research other options XD.
2)Use embedded code to go in and access the databases and return a Data
Reader or something. This is okay, but a pain to have to add to
multiple reports.
3)and the winner is... custom Data Processing Extentions(DPEs). DPEs
are what you use to make connection strings in the first place, and
there are ways to make your own that can take variable paramaters and
do all sorts of nifty things for you. This way is very difficult (the
first time or if you have forgotten how) because you have to make the
server trust it, and from what I have heard MSDN documentation on this
subject is incorrect. The actual coding itself shouldn't be a problem
for a moderate developer.
Option 3 is what I am investigating, I will post an update as to what
my final solution is.
Lance M|||I have a need for the same functionality. Have you had any success with
option 3?|||Okay, I have finished testing (for the most part). Provided that I can
install the DPE everything should work perfectly (knock on synthetic
wood). I created the 6 or so class files required for a DPE, but most
importantly I managed to connect dynamically to the databases and
return a table made of the elements of data queried from the DBs. This
table will then be passed to the ExecuteReader method of one of those
classes, and if I followed any samples (that had poor/no documentation)
right, then I should be able to summon those fields within any report
that uses a dataset based on that DPE. I also have a grand hope that I
will be able to somehow execute stored procedures with my DPE as well,
thus making it more robust and user friendly (haha).
One issue that I would like to note is that if the table you are
building happens to be gargantuan, the report could be incredibly slow
or just refuse to show up even fashionably late. In these cases, you
may want to have the report run overnight, and use a snapshot that is
somewhat up to date for report viewers. If you absolutely must have
these types of reports running any time a user selects them, I suggest
you look for a new career.
Good Luck!
Lance M