Another Question

I want to create a horizontal table as follows:
Ingot 12345 12345 12345
Traveler 98786 87657 77675
Pieces 15 20 12
Step 1 x x x
Step 2 x x x
Step 3 x x x
Step 4 x x x
Step 5 x x x
Step 6 x x
Step 7 x x
...
Step 19
As you can see the columns for the steps are fixed. I know which step each
traveler is on so I want to populate the table with x's until I get to the
last step. As you can see from this report, the first and third travelers
are about the same and the second is stuck on step 5. The managers can look
at this and see that the second traveler will produce a hole later on. So
how could I create this table in SSRS? Keep in mind the steps are
predefined and will not change. So the information returned from the query
would be similar to the following
Ingot, Traveler, Pieces, Step
12345 98786 15 7
12345 87657 20 5
12345 77675 12 7
...
Thanks.On May 11, 2:39 pm, "John Wright" <riley_wrig...@.hotmail.com> wrote:
> I want to create a horizontal table as follows:
> Ingot 12345 12345 12345
> Traveler 98786 87657 77675
> Pieces 15 20 12
> Step 1 x x x
> Step 2 x x x
> Step 3 x x x
> Step 4 x x x
> Step 5 x x x
> Step 6 x x
> Step 7 x x
> ...
> Step 19
> As you can see the columns for the steps are fixed. I know which step each
> traveler is on so I want to populate the table with x's until I get to the
> last step. As you can see from this report, the first and third travelers
> are about the same and the second is stuck on step 5. The managers can look
> at this and see that the second traveler will produce a hole later on. So
> how could I create this table in SSRS? Keep in mind the steps are
> predefined and will not change. So the information returned from the query
> would be similar to the following
> Ingot, Traveler, Pieces, Step
> 12345 98786 15 7
> 12345 87657 20 5
> 12345 77675 12 7
> ...
> Thanks.
You will most likely want to use a matrix report where the pivoted
column (say Column_x) can have values: Ingot, Traveler and Pieces and
then have a normal column called Step. So your stored procedure/query
that will be sourcing the report should have an output like the
following:
Column_x Value Step
-- -- --
Ingot 12345 7
Traveler 98786 7
Pieces 15 7
Ingot 12345 5
Traveler 87657 5
Pieces 20 5
Ingot 12345 7
Traveler 77675 7
Pieces 12 7
Where Column_x will be the pivot column (it will turn into 3 columns
in the report: Ingot, Traveler and Pieces). Value will be the details
displayed for the pivot column. And Step is the row value (amounting
to a column). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Analysis Services Step by Step - connection problem

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

I downloaded the trial version from MS and installed in om my laptop from where im running my tutorial - what could be wrong? (Im a newbie to SQL so I have no clue)

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

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

|||

Edward Melomed wrote:

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

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

I have the following services running:

SQL Server, SQL Server Agent, SQL Server Browser, SQL Server FullText Search, SQL Server Integration Services and SQL Server VSS Writer - I can't see any Analysis related services on my services list?

|||

It is working now - thanks alot for your help.

I reinstalled my solution and for some reason I didnt have the Analasis services correctly installed.

Analysis Services Migration

Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
SQL 2005 but get a weird error after the first step in the migration.
It asks me for a Source and Destination server and when I specify my
old and new server and click Next I get this error:
Source server: Cannot connect to the repository.
Analysis server: myoldserver.com
Error:
Cannot open database "xxx" requested by the login. The login failed.
I know my login should work since my login credentials are the same
between servers. It would be nice if there was an option in the
migration wizard for specifying your login method. Does anyone know
what the problem could be? Thanks much
-Adam
Yeah the AS stuff is on the same machine as the database is. I'm
trying to get that data to get moved to our new SQL2005 server, with no
luck.
Thanks
-Adam
|||Did you use Migration wizard?
Where do you have your fact and dimesnion tables? Have you migrated that
first to Sql Server 2005.
First migrate OLAP design(Fact and Dimesion table's) to Sql Server 2005. Try
to mirate that DB itself. As we create Cube in Sql Server 2000 we specify
DataSource as this DB. And when we try to migrate Cubes directly it may fail
as it wont find the OLAP DB.
Try this and let me know. We faced the same issue when we tried this it
worked. Let me know whats the cause of yours.
Thanks,
Sree
"Adam Plocher" wrote:

> Yeah the AS stuff is on the same machine as the database is. I'm
> trying to get that data to get moved to our new SQL2005 server, with no
> luck.
> Thanks
> -Adam
>
|||Thanks Sree, that helped but now I'm receiving another error. By
copying the database over to the new server and running the migration
wizard again, I now get the following error:
Source server: ActiveX component can't create object
This occurs at the same place as the previous error I was getting;
right after you specify a source and destination server and click Next.
I've done a lot of searching around for this error and almost all
occurences are from MS Access (not all though). This migration wizard
is starting to bug me.
Anyway, do you (or anyone else) know what this error could mean and
what I could do to fix it? I've tried re-registring my dao dll on both
the source and destination - although that's probably an Access
specific thing.
Thanks!
-Adam

Analysis Services Migration

Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
SQL 2005 but get a weird error after the first step in the migration.
It asks me for a Source and Destination server and when I specify my
old and new server and click Next I get this error:
Source server: Cannot connect to the repository.
Analysis server: myoldserver.com
Error:
Cannot open database "xxx" requested by the login. The login failed.
I know my login should work since my login credentials are the same
between servers. It would be nice if there was an option in the
migration wizard for specifying your login method. Does anyone know
what the problem could be? Thanks much
-Adamwas your old AS machine on the same physical server as your relational
database?
sure seems to me like a simple double-hop issue
"Adam Plocher" <aplocher@.gmail.com> wrote in message
news:1139604687.474624.190780@.o13g2000cwo.googlegroups.com...
> Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
> SQL 2005 but get a weird error after the first step in the migration.
> It asks me for a Source and Destination server and when I specify my
> old and new server and click Next I get this error:
> Source server: Cannot connect to the repository.
> Analysis server: myoldserver.com
> Error:
> Cannot open database "xxx" requested by the login. The login failed.
> I know my login should work since my login credentials are the same
> between servers. It would be nice if there was an option in the
> migration wizard for specifying your login method. Does anyone know
> what the problem could be? Thanks much
> -Adam
>|||Yeah the AS stuff is on the same machine as the database is. I'm
trying to get that data to get moved to our new SQL2005 server, with no
luck.
Thanks
-Adam|||Did you use Migration wizard?
Where do you have your fact and dimesnion tables? Have you migrated that
first to Sql Server 2005.
First migrate OLAP design(Fact and Dimesion table's) to Sql Server 2005. Try
to mirate that DB itself. As we create Cube in Sql Server 2000 we specify
DataSource as this DB. And when we try to migrate Cubes directly it may fail
as it wont find the OLAP DB.
Try this and let me know. We faced the same issue when we tried this it
worked. Let me know whats the cause of yours.
Thanks,
Sree
"Adam Plocher" wrote:
> Yeah the AS stuff is on the same machine as the database is. I'm
> trying to get that data to get moved to our new SQL2005 server, with no
> luck.
> Thanks
> -Adam
>|||Thanks Sree, that helped but now I'm receiving another error. By
copying the database over to the new server and running the migration
wizard again, I now get the following error:
Source server: ActiveX component can't create object
This occurs at the same place as the previous error I was getting;
right after you specify a source and destination server and click Next.
I've done a lot of searching around for this error and almost all
occurences are from MS Access (not all though). This migration wizard
is starting to bug me.
Anyway, do you (or anyone else) know what this error could mean and
what I could do to fix it? I've tried re-registring my dao dll on both
the source and destination - although that's probably an Access
specific thing.
Thanks!
-Adam

Analysis Services Migration

Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
SQL 2005 but get a weird error after the first step in the migration.
It asks me for a Source and Destination server and when I specify my
old and new server and click Next I get this error:
Source server: Cannot connect to the repository.
Analysis server: myoldserver.com
Error:
Cannot open database "xxx" requested by the login. The login failed.
I know my login should work since my login credentials are the same
between servers. It would be nice if there was an option in the
migration wizard for specifying your login method. Does anyone know
what the problem could be? Thanks much
-AdamYeah the AS stuff is on the same machine as the database is. I'm
trying to get that data to get moved to our new SQL2005 server, with no
luck.
Thanks
-Adam|||Did you use Migration wizard?
Where do you have your fact and dimesnion tables? Have you migrated that
first to Sql Server 2005.
First migrate OLAP design(Fact and Dimesion table's) to Sql Server 2005. Try
to mirate that DB itself. As we create Cube in Sql Server 2000 we specify
DataSource as this DB. And when we try to migrate Cubes directly it may fail
as it wont find the OLAP DB.
Try this and let me know. We faced the same issue when we tried this it
worked. Let me know whats the cause of yours.
Thanks,
Sree
"Adam Plocher" wrote:

> Yeah the AS stuff is on the same machine as the database is. I'm
> trying to get that data to get moved to our new SQL2005 server, with no
> luck.
> Thanks
> -Adam
>|||Thanks Sree, that helped but now I'm receiving another error. By
copying the database over to the new server and running the migration
wizard again, I now get the following error:
Source server: ActiveX component can't create object
This occurs at the same place as the previous error I was getting;
right after you specify a source and destination server and click Next.
I've done a lot of searching around for this error and almost all
occurences are from MS Access (not all though). This migration wizard
is starting to bug me.
Anyway, do you (or anyone else) know what this error could mean and
what I could do to fix it? I've tried re-registring my dao dll on both
the source and destination - although that's probably an Access
specific thing.
Thanks!
-Adam