We're running Commerce Server 2002 on Windows Server 2000 SP4, SQL Server
2000 and Analysis Services.

In the process of setting up the BizDesk reports we've reached the point of
populating the DW database.

This step is described as locating and running the DW Import Wizard DTS
package, but the package is not there.

Should this package be additionally installed or maybe put together, or is
it somewhere else other than the DTS - Local Packages directory in SQL Serve
r?

If we try to "Find" any BizDesk reports at this stage, nothing is returned.

Any help would be much appreciated.

Thank you!

[ Post a follow-up to this message ]

Nikola,

Have you opened the Commerce Server Manager | Global Resources and tried
right-clicking the Data Warehouse component and choosing 'All Tasks | Import
Data...'?  That will lead to the DW Import Wizard.  Once you select all the
parameters for your import, you have the options of running the package
immediately and/or saving it as a DTS package.

HTH

Ken

"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:46096D1A-D83D-4259-A65E-52F1B683ED25@microsoft.com...
> We're running Commerce Server 2002 on Windows Server 2000 SP4, SQL Server
> 2000 and Analysis Services.
>
> In the process of setting up the BizDesk reports we've reached the point
> of
> populating the DW database.
>
> This step is described as locating and running the DW Import Wizard DTS
> package, but the package is not there.
>
> Should this package be additionally installed or maybe put together, or is
> it somewhere else other than the DTS - Local Packages directory in SQL
> Server?
>
> If we try to "Find" any BizDesk reports at this stage, nothing is
> returned.
>
> Any help would be much appreciated.
>
> Thank you!
>

[ Post a follow-up to this message ]

The import package itself is not created during product installation, this
must be created for each site in order to specify the correct site,
location and log files.  Go into SQL Enterprise manager, DTS, and create
new package.

Select "Web Server Log Import (Commerce Server)" and specify the log files
to be imported.  Save the package and run it

You might want to review the Data Warehouse product documentation sections
further as there are a few other steps to perform before you can run some
of the reports - such as importing user data, Transaction data, product
catalog data - etc. based on what data is required to be returned in the
reports.

Hope this helps!

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

EBusiness Server Team
--------------------
Thread-Topic: BizDesk reports - DW Import Wizard DTS
thread-index: AcSesuJoLcLRSw3tSSyWoY3CQ5yVLA==
X-WBNR-Posting-Host: 202.135.192.158
From: examnotes <Nikola@discussions.microsoft.com>
Subject: BizDesk reports - DW Import Wizard DTS
Date: Sun, 19 Sep 2004 18:41:01 -0700
Lines: 18
Message-ID: <46096D1A-D83D-4259-A65E-52F1B683ED25@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.catalog:4954
X-Tomcat-NG: microsoft.public.commerceserver.catalog

We're running Commerce Server 2002 on Windows Server 2000 SP4, SQL Server
2000 and Analysis Services.

In the process of setting up the BizDesk reports we've reached the point of
populating the DW database.

This step is described as locating and running the DW Import Wizard DTS
package, but the package is not there.

Should this package be additionally installed or maybe put together, or is
it somewhere else other than the DTS - Local Packages directory in SQL
Server?

If we try to "Find" any BizDesk reports at this stage, nothing is returned.

Any help would be much appreciated.

Thank you!

[ Post a follow-up to this message ]

Thanks for the reply Ken and John!

I followed Ken's approach to start with and got to the point of executing
the result from the DW Import Wizard. I tried the following scenarios:

1) I selected all the types of data to import:
- Web Server Logs
- Resolve IP addresses
- Product Catalog
- Transactions

This process stopped executing on the "Web Server Log Import" step, and it
didn't give any details of the error.

2) I selected the following types of data to import:
- Resolve IP addresses
- Product Catalog
- Transactions

This process stopped executing on the "Report Preparation" step, and it
didn't give any details of the error.

Any ideas of the errors' details?

Another thing is that the documentation mentions the standard BizDesk
reports that come with Commerce Server. If the above process was to complete
successfully should those reports appear in BizDesk under Analysis ->
Reports, or are there some other extra steps involved to get them running?

Thanks a lot!

Nikola

"Ken Brown" wrote:

> Nikola,
>
> Have you opened the Commerce Server Manager | Global Resources and tried
> right-clicking the Data Warehouse component and choosing 'All Tasks | Impo
rt
> Data...'?  That will lead to the DW Import Wizard.  Once you select all th
e
> parameters for your import, you have the options of running the package
> immediately and/or saving it as a DTS package.
>
> HTH
>
> Ken
>
> "Nikola" <Nikola@discussions.microsoft.com> wrote in message
> news:46096D1A-D83D-4259-A65E-52F1B683ED25@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

Nikola,

I'm glad you were able to at least get responses from the process.

Regarding the Web Server Logs, you want to make sure that the process is
looking in the correct location.  For mine, I had to look in <% windir
%>\system32\Logfiles\W3SVC1 where each day is listed with a specific date
name.

I believe, but I'm not certain, that the Report Preparation process can fail
if there is no date/time information which is provided by the web server
logs.  It could be that or a connection problem.

Finally, the report names may not be showing up due to a problem with your
connection string in the Analysis Services database for your site.  Do you
have Commerce, SQL and Analysis Services all running on the same machine,
separate machines in the same domain, or separate machines in different
domains?  This was a big issue that I ran into in getting my reports to
work.

Hope this helps,

Ken

"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:2B279CE9-CEE0-4B28-9427-66C4F451B243@microsoft.com...[vbcol=seagreen]
> Thanks for the reply Ken and John!
>
> I followed Ken's approach to start with and got to the point of executing
> the result from the DW Import Wizard. I tried the following scenarios:
>
> 1) I selected all the types of data to import:
> - Web Server Logs
> - Resolve IP addresses
> - Product Catalog
> - Transactions
>
> This process stopped executing on the "Web Server Log Import" step, and it
> didn't give any details of the error.
>
> 2) I selected the following types of data to import:
> - Resolve IP addresses
> - Product Catalog
> - Transactions
>
> This process stopped executing on the "Report Preparation" step, and it
> didn't give any details of the error.
>
> Any ideas of the errors' details?
>
> Another thing is that the documentation mentions the standard BizDesk
> reports that come with Commerce Server. If the above process was to
> complete
> successfully should those reports appear in BizDesk under Analysis ->
> Reports, or are there some other extra steps involved to get them running?
>
> Thanks a lot!
>
> Nikola
>
> "Ken Brown" wrote:
> 

[ Post a follow-up to this message ]

Hi Ken, thank you for your reply.

I got the "Web Server Log Import" step to execute properly after locating
the right folder, but the process still breaks on the "Report Preparation"
step, which is the last step, and again with no details of what might have
gone wrong. The log files have date/time information in them, and all the
connections that I'm aware of are working properly.

We have Commerce Server and SQL Server running on separate machines in
different domains, and both machines have Analysis Services installed on the
m.

Thanks a lot again for your reply.

Nikola

"Ken Brown" wrote:

> Nikola,
>
> I'm glad you were able to at least get responses from the process.
>
> Regarding the Web Server Logs, you want to make sure that the process is
> looking in the correct location.  For mine, I had to look in <% windir
> %>\system32\Logfiles\W3SVC1 where each day is listed with a specific date
> name.
>
> I believe, but I'm not certain, that the Report Preparation process can fa
il
> if there is no date/time information which is provided by the web server
> logs.  It could be that or a connection problem.
>
> Finally, the report names may not be showing up due to a problem with your
> connection string in the Analysis Services database for your site.  Do you
> have Commerce, SQL and Analysis Services all running on the same machine,
> separate machines in the same domain, or separate machines in different
> domains?  This was a big issue that I ran into in getting my reports to
> work.
>
> Hope this helps,
>
> Ken
>
> "Nikola" <Nikola@discussions.microsoft.com> wrote in message
> news:2B279CE9-CEE0-4B28-9427-66C4F451B243@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

Nikola,

I'm glad we're making some headway.

One thing you should try is to go to the Analysis Manager and expand the
server to show the database for your site's DW.  Right-click on the database
and choose 'Process the Database'.  That will open a dialog and show you
step-by-step what goes on during processing (this is also what the Report
Processing process does).  If it actually succeeds, that's great.  If it
doesn't, it'll give you an idea of where the Report Processing is failing.

Let me know what happens,

Ken

"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:6D7D3A69-90FA-4CA1-B728-CA4071738072@microsoft.com...[vbcol=seagreen]
> Hi Ken, thank you for your reply.
>
> I got the "Web Server Log Import" step to execute properly after locating
> the right folder, but the process still breaks on the "Report Preparation"
> step, which is the last step, and again with no details of what might have
> gone wrong. The log files have date/time information in them, and all the
> connections that I'm aware of are working properly.
>
> We have Commerce Server and SQL Server running on separate machines in
> different domains, and both machines have Analysis Services installed on
> them.
>
> Thanks a lot again for your reply.
>
> Nikola
>
> "Ken Brown" wrote:
> 

[ Post a follow-up to this message ]

Hi Ken, I'm glad we're making some headway as well, thanks to your help.

When I go to "Analysis Server", expand the SQL Server and right-click on the
DB, the "Process the Database" option is disabled.

I set up this DB manually by right-clicking on the server and selecting the
"New Database..." option. Then I set a data source for it by right-clicking
the "Data Sources" subfolder and selecting the "New Data Source..." option.

There are a few other DBs from sample sites that we've installed, and they
have the "Process the Database" option enabled, but these DBs were created b
y
the install process. I couldn't notice any difference in the "Data Sources"
subfolder setup, although they have information in the "Cubes" and "Shared
Dimensions" subfolders.

Thanks for your help Ken!

Nikola

"Ken Brown" wrote:

> Nikola,
>
> I'm glad we're making some headway.
>
> One thing you should try is to go to the Analysis Manager and expand the
> server to show the database for your site's DW.  Right-click on the databa
se
> and choose 'Process the Database'.  That will open a dialog and show you
> step-by-step what goes on during processing (this is also what the Report
> Processing process does).  If it actually succeeds, that's great.  If it
> doesn't, it'll give you an idea of where the Report Processing is failing.
>
> Let me know what happens,
>
> Ken
>
> "Nikola" <Nikola@discussions.microsoft.com> wrote in message
> news:6D7D3A69-90FA-4CA1-B728-CA4071738072@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

Nikola,

That's why the Report creation process fails is that your Cube and Shared
Dimension folders are empty.  You should be able to use the Data Warehouse
pup file to create those cubes and shared dimensions.  Alternatively, if you
already have a test commerce site, you can copy the cubes and shared
dimensions from one database to another.

HTH,

Ken

"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:50F640B4-1DFE-45E1-879D-82690665CA4B@microsoft.com...[vbcol=seagreen]
> Hi Ken, I'm glad we're making some headway as well, thanks to your help.
>
> When I go to "Analysis Server", expand the SQL Server and right-click on
> the
> DB, the "Process the Database" option is disabled.
>
> I set up this DB manually by right-clicking on the server and selecting
> the
> "New Database..." option. Then I set a data source for it by
> right-clicking
> the "Data Sources" subfolder and selecting the "New Data Source..."
> option.
>
> There are a few other DBs from sample sites that we've installed, and they
> have the "Process the Database" option enabled, but these DBs were created
> by
> the install process. I couldn't notice any difference in the "Data
> Sources"
> subfolder setup, although they have information in the "Cubes" and "Shared
> Dimensions" subfolders.
>
> Thanks for your help Ken!
>
> Nikola
>
> "Ken Brown" wrote:
> 

[ Post a follow-up to this message ]

Hi Ken, thank you for your reply.

I copied the Cubes and Shared Dimensions from one of my sample sites across
and the "Process the Database" options became enabled.

When I clicked this option the process started with errors from one of the
dimensions not being able to process properly. I looked at the details of th
e
error and the dimension was trying to use a table that didn't exist. I looke
d
at the tables in the DB and the table was there but the owner was different,
so I modified the dimension to use this table with the correct owner. I had
to repeat this process for most of the dimensions. There was one dimension
that was trying to use a table that didn't exist at all, so I had to remove
it.

I had to do the same with the cubes as well, although I had to remove more
than one of them as they were trying to use tables that didn't exist.

After all that the database processed successfully, which was great to see.

Then I tried to import data with the DW Import Wizard and the process
stopped executing on the "Report Preparation" step again, which was a bit
disappointing.

Also there are still no reports in BizDesk.

Thanks a lot for your continuous replies, they give a lot of hope.

Nikola

"Ken Brown" wrote:

> Nikola,
>
> That's why the Report creation process fails is that your Cube and Shared
> Dimension folders are empty.  You should be able to use the Data Warehouse
> pup file to create those cubes and shared dimensions.  Alternatively, if y
ou
> already have a test commerce site, you can copy the cubes and shared
> dimensions from one database to another.
>
> HTH,
>
> Ken
>
> "Nikola" <Nikola@discussions.microsoft.com> wrote in message
> news:50F640B4-1DFE-45E1-879D-82690665CA4B@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]