|
Home > Archive > Commerce Server Catalog > October 2004 > BizDesk reports - DW Import Wizard DTS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizDesk reports - DW Import Wizard DTS
|
|
| Nikola 2004-09-22, 9:48 pm |
| 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!
| |
| Ken Brown 2004-09-22, 9:48 pm |
| 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!
>
| |
| John Inman [MSFT] 2004-09-22, 9:48 pm |
| 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: =?Utf-8?B?Tmlrb2xh?= <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!
| |
| Nikola 2004-09-23, 9:18 am |
| 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 | 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...
>
>
>
| |
| Ken Brown 2004-09-23, 9:18 am |
| 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:
>
| |
| Nikola 2004-09-23, 9:18 am |
| 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:
> 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...
>
>
>
| |
| Ken Brown 2004-09-23, 9:18 am |
| 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:
>
| |
| Nikola 2004-09-23, 9:18 am |
| 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:
> 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...
>
>
>
| |
| Ken Brown 2004-09-23, 5:51 pm |
| 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:
>
| |
| Nikola 2004-09-23, 5:51 pm |
| 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 the
error and the dimension was trying to use a table that didn't exist. I looked
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 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...
>
>
>
| |
| Ken Brown 2004-09-24, 5:49 pm |
| Nikola,
I'm going to have to dig a little deeper into my memory banks and try to
reproduce all the steps it took for me to get my data warehouse running. It
still sounds like connection or permission problems, but I'll have to
research a little more.
Ken
"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:8D6752C3-B16E-4746-A9DC-4729B8A9698C@microsoft.com...[vbcol=seagreen]
> 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
> the
> error and the dimension was trying to use a table that didn't exist. I
> looked
> 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:
>
| |
| Robert Bogue 2004-09-29, 8:03 pm |
| Did you remove any of the profiles that came with CS? If those profiles are
removed some of the cubes get unhappy. I generally suggest leaving the
existing profiles in the site and add your own to them.
Rob
--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:8D6752C3-B16E-4746-A9DC-4729B8A9698C@microsoft.com...
> 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
the
> error and the dimension was trying to use a table that didn't exist. I
looked
> 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.[vbcol=seagreen]
>
> 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:
>
Shared[vbcol=seagreen]
Warehouse[vbcol=seagreen]
you[vbcol=seagreen]
help.[vbcol=seagreen]
on[vbcol=seagreen]
selecting[vbcol=seagreen]
they[vbcol=seagreen]
created[vbcol=seagreen]
"Shared[vbcol=seagreen]
the[vbcol=seagreen]
you[vbcol=seagreen]
Report[vbcol=seagreen]
it[vbcol=seagreen]
might[vbcol=seagreen]
all[vbcol=seagreen]
in[vbcol=seagreen]
installed[vbcol=seagreen]
process[vbcol=seagreen]
windir[vbcol=seagreen]
specific[vbcol=seagreen]
process[vbcol=seagreen]
with[vbcol=seagreen]
Do[vbcol=seagreen]
reports[vbcol=seagreen]
step,[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]
them[vbcol=seagreen]
and[vbcol=seagreen]
Tasks[vbcol=seagreen]
select[vbcol=seagreen]
SP4,[vbcol=seagreen]
reached[vbcol=seagreen]
directory[vbcol=seagreen]
nothing is[vbcol=seagreen]
| |
| Nikola 2004-09-29, 8:03 pm |
| Hi Robert,
I didn't remove any of the profiles that came with CS, but I did modify the
User and Organization profile. I also added some of my own profiles. I hope
modifying the profiles doesn't cause any trouble.
Thanks for your reply!
Nikola
"Robert Bogue" wrote:
> Did you remove any of the profiles that came with CS? If those profiles are
> removed some of the cubes get unhappy. I generally suggest leaving the
> existing profiles in the site and add your own to them.
>
> Rob
>
> --
> Robert Bogue
> Microsoft MVP Server-Networking
> MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
> Server+, Security+, CDIA+, E-Biz+
> Crowe Chizek and Co LLC
> "Nikola" <Nikola@discussions.microsoft.com> wrote in message
> news:8D6752C3-B16E-4746-A9DC-4729B8A9698C@microsoft.com...
> across
> the
> looked
> different,
> had
> remove
> see.
> Shared
> Warehouse
> you
> help.
> on
> selecting
> they
> created
> "Shared
> the
> you
> Report
> it
> might
> all
> in
> installed
> process
> windir
> specific
> process
> with
> Do
> reports
> step,
> and
> to
> them
> and
> Tasks
> select
> SP4,
> reached
> directory
> nothing is
>
>
>
| |
| Ken Brown 2004-10-02, 8:59 pm |
| Nikola,
I appologize for the long delay in responding. One thing you may want to
try is to completely delete the Data Warehousing from the project and un-pup
the DW.pup file again. You'll have to get rid of everything that pertains
to the data warehouse, but it's all comprised of information that's in your
commerce database and web server logs, so it's really not that scary of an
issue. By doing this, you'll rebuild all the analysis services to commerce
defaults for your site. I've actually had to do this a few times during
development. I'm not honestly sure how it will bring in/affect your
modifications, but it really won't hurt them.
Let me know if you have further questions and how it goes for you.
Ken
"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:29DA4187-92D9-442B-8562-5CE432EEF5B2@microsoft.com...[vbcol=seagreen]
> Hi Robert,
>
> I didn't remove any of the profiles that came with CS, but I did modify
> the
> User and Organization profile. I also added some of my own profiles. I
> hope
> modifying the profiles doesn't cause any trouble.
>
> Thanks for your reply!
>
> Nikola
>
> "Robert Bogue" wrote:
>
| |
| Robert Bogue 2004-10-03, 5:50 pm |
| The modifications are fine. Almost every client I have does this ...
However, in our modifications we don't delete fields.
You should also be aware there are some quirks around changing the names of
underlying data tables for a profile -- and profile names shouldn't be
changed.
Ken's suggestion to unpup again is a good one.
Rob
--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:29DA4187-92D9-442B-8562-5CE432EEF5B2@microsoft.com...
> Hi Robert,
>
> I didn't remove any of the profiles that came with CS, but I did modify
the
> User and Organization profile. I also added some of my own profiles. I
hope[vbcol=seagreen]
> modifying the profiles doesn't cause any trouble.
>
> Thanks for your reply!
>
> Nikola
>
> "Robert Bogue" wrote:
>
are[vbcol=seagreen]
Project+,[vbcol=seagreen]
the[vbcol=seagreen]
of[vbcol=seagreen]
I[vbcol=seagreen]
dimension[vbcol=seagreen]
more[vbcol=seagreen]
bit[vbcol=seagreen]
Alternatively, if[vbcol=seagreen]
right-click[vbcol=seagreen]
Source..."[vbcol=seagreen]
and[vbcol=seagreen]
expand[vbcol=seagreen]
the[vbcol=seagreen]
show[vbcol=seagreen]
the[vbcol=seagreen]
If[vbcol=seagreen]
after[vbcol=seagreen]
and[vbcol=seagreen]
machines[vbcol=seagreen]
process.[vbcol=seagreen]
<%[vbcol=seagreen]
web[vbcol=seagreen]
problem[vbcol=seagreen]
site.[vbcol=seagreen]
same[vbcol=seagreen]
of[vbcol=seagreen]
Import"[vbcol=seagreen]
step,[vbcol=seagreen]
standard[vbcol=seagreen]
was[vbcol=seagreen]
Resources[vbcol=seagreen]
'All[vbcol=seagreen]
you[vbcol=seagreen]
the[vbcol=seagreen]
message[vbcol=seagreen]
Import[vbcol=seagreen]
put[vbcol=seagreen]
| |
| Nikola 2004-10-03, 5:50 pm |
| Hi Ken and Robert, thanks for your replies.
I deleted the Data Warehousing from the project and un-pupped the DW.pup
file again.
The Site and Global resources were recreated and there was no entry in the
Analysis Servers SQL Server. I have a feeling that if I was to create the DB
with Cubes and Shared Dimensions manually - like last time - that I would end
up at the same place.
I never expected this process to be so complicated. What resources did you
use/read when setting up the DW/Reports, because all the resources that I
read covered this topic in not enough detail. I could be missing a small step
somewhere, so something that describes this process in a step-by-step manner
would be very useful.
Thanks a lot for your continuous replies, I hope we'll get to the bottom of
this.
Nikola
"Ken Brown" wrote:
> Nikola,
>
> I appologize for the long delay in responding. One thing you may want to
> try is to completely delete the Data Warehousing from the project and un-pup
> the DW.pup file again. You'll have to get rid of everything that pertains
> to the data warehouse, but it's all comprised of information that's in your
> commerce database and web server logs, so it's really not that scary of an
> issue. By doing this, you'll rebuild all the analysis services to commerce
> defaults for your site. I've actually had to do this a few times during
> development. I'm not honestly sure how it will bring in/affect your
> modifications, but it really won't hurt them.
>
> Let me know if you have further questions and how it goes for you.
>
> Ken
>
> "Nikola" <Nikola@discussions.microsoft.com> wrote in message
> news:29DA4187-92D9-442B-8562-5CE432EEF5B2@microsoft.com...
>
>
>
| |
| Robert Bogue 2004-10-03, 9:11 pm |
| What do you mean that there was not entry in Analysis Server SQL Server?
Rob
--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"Nikola" <Nikola@discussions.microsoft.com> wrote in message
news:7B61CEA3-A21C-4272-8F5F-494BD6CEC7FB@microsoft.com...
> Hi Ken and Robert, thanks for your replies.
>
> I deleted the Data Warehousing from the project and un-pupped the DW.pup
> file again.
> The Site and Global resources were recreated and there was no entry in the
> Analysis Servers SQL Server. I have a feeling that if I was to create the
DB
> with Cubes and Shared Dimensions manually - like last time - that I would
end
> up at the same place.
>
> I never expected this process to be so complicated. What resources did you
> use/read when setting up the DW/Reports, because all the resources that I
> read covered this topic in not enough detail. I could be missing a small
step
> somewhere, so something that describes this process in a step-by-step
manner
> would be very useful.
>
> Thanks a lot for your continuous replies, I hope we'll get to the bottom
of[vbcol=seagreen]
> this.
>
> Nikola
>
> "Ken Brown" wrote:
>
to[vbcol=seagreen]
un-pup[vbcol=seagreen]
pertains[vbcol=seagreen]
your[vbcol=seagreen]
an[vbcol=seagreen]
commerce[vbcol=seagreen]
modify[vbcol=seagreen]
profiles[vbcol=seagreen]
the[vbcol=seagreen]
sites[vbcol=seagreen]
of[vbcol=seagreen]
details[vbcol=seagreen]
exist. I[vbcol=seagreen]
owner. I[vbcol=seagreen]
to[vbcol=seagreen]
remove[vbcol=seagreen]
exist.[vbcol=seagreen]
to[vbcol=seagreen]
process[vbcol=seagreen]
a[vbcol=seagreen]
and[vbcol=seagreen]
Alternatively,[vbcol=seagreen]
shared[vbcol=seagreen]
your[vbcol=seagreen]
Source..."[vbcol=seagreen]
installed,[vbcol=seagreen]
were[vbcol=seagreen]
"Data[vbcol=seagreen]
and[vbcol=seagreen]
on[vbcol=seagreen]
and[vbcol=seagreen]
the[vbcol=seagreen]
great.[vbcol=seagreen]
is[vbcol=seagreen]
after[vbcol=seagreen]
"Report[vbcol=seagreen]
what[vbcol=seagreen]
them,[vbcol=seagreen]
the[vbcol=seagreen]
in <%[vbcol=seagreen]
the[vbcol=seagreen]
your[vbcol=seagreen]
in[vbcol=seagreen]
my[vbcol=seagreen]
message[vbcol=seagreen]
point[vbcol=seagreen]
following[vbcol=seagreen]
Import"[vbcol=seagreen]
Preparation"[vbcol=seagreen]
standard[vbcol=seagreen]
process[vbcol=seagreen]
get[vbcol=seagreen]
you[vbcol=seagreen]
running[vbcol=seagreen]
message[vbcol=seagreen]
news:46096D1A-D83D-4259-A65E-52F1B683ED25@microsoft.com...[vbcol=seagreen]
2000[vbcol=seagreen]
put[vbcol=seagreen]
| |
| Nikola 2004-10-04, 5:52 pm |
| Hi Robert,
Previously I had installed a couple of CS sample sites, and they seem to
have entries in Analysis Server with Cubes and Shared Dimensions. I was
expecting an entry to be created for my own site when creating the Data
Warehouse. Last time I had to create it manually and copy the Cubes and
Shared Dimensions from one the sample sites, and then modify some of them to
get them to be processed.
Thanks,
Nikola
"Robert Bogue" wrote:
> What do you mean that there was not entry in Analysis Server SQL Server?
>
> Rob
>
> --
> Robert Bogue
> Microsoft MVP Server-Networking
> MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
> Server+, Security+, CDIA+, E-Biz+
> Crowe Chizek and Co LLC
> "Nikola" <Nikola@discussions.microsoft.com> wrote in message
> news:7B61CEA3-A21C-4272-8F5F-494BD6CEC7FB@microsoft.com...
> DB
> end
> step
> manner
> of
> to
> un-pup
> pertains
> your
> an
> commerce
> modify
> profiles
> the
> sites
> of
> details
> exist. I
> owner. I
> to
> remove
> exist.
> to
> process
> a
> and
> Alternatively,
> shared
> your
> Source..."
> installed,
> were
> "Data
> and
> on
> and
> the
> great.
> is
> after
> "Report
> what
> them,
> the
> in <%
> the
> your
> in
> my
> message
> point
> following
> Import"
> Preparation"
> standard
> process
> get
> you
> running
> message
> news:46096D1A-D83D-4259-A65E-52F1B683ED25@microsoft.com...
> 2000
> put
>
>
>
| |
| markpisc 2004-10-15, 9:11 pm |
| Hi All!
1st time posting.
Nikola,
Have you had any luck yet?
I am having what apperas to be the exact same problem and have spent a
frustrating week trying to figure it out. I hope something I report can help
us find a solution.
On unpack of any site, the Analysis Server does not get populated with the
Olap Database, Cubes, etc...
I can't seem to get Commerce Server 2002 to create the database. In my case
I can't even get a sample created (like from the DW.pup) to try to copy and
modify to use with my existing site.
I have Commerce Server on a Windows 2000 server machine and SQL 2000 and
Analysis Services on a separate SQL Server machine.
I would think there would be a DTS package or something that would you could
manually run to that would create the Olap Database.
I looked in the c:\pup.log file and it says that it creates a
c:\commerceolap.log file on creation of Cubes but the log file never is
created.
Any help I could get would greatly appreciated.
Thank you.
Mark
"Nikola" wrote:
[vbcol=seagreen]
> Hi Robert,
>
> Previously I had installed a couple of CS sample sites, and they seem to
> have entries in Analysis Server with Cubes and Shared Dimensions. I was
> expecting an entry to be created for my own site when creating the Data
> Warehouse. Last time I had to create it manually and copy the Cubes and
> Shared Dimensions from one the sample sites, and then modify some of them to
> get them to be processed.
>
> Thanks,
>
> Nikola
>
> "Robert Bogue" wrote:
>
| |
| Nikola 2004-10-15, 9:11 pm |
| Hi Mark,
I haven't had any luck with this issue yet, it's been quite a while now.
The sample Analysis Server DBs with Cubes and Shared Dimensions I have are
from a couple of sample sites I installed - Retail2000 and FourthCoffee, the
DW.pup didn't create any.
I really hope that we can find a solution for this.
Regards,
Nikola
"markpisc" wrote:
[vbcol=seagreen]
> Hi All!
>
> 1st time posting.
>
> Nikola,
>
> Have you had any luck yet?
>
> I am having what apperas to be the exact same problem and have spent a
> frustrating week trying to figure it out. I hope something I report can help
> us find a solution.
>
> On unpack of any site, the Analysis Server does not get populated with the
> Olap Database, Cubes, etc...
>
> I can't seem to get Commerce Server 2002 to create the database. In my case
> I can't even get a sample created (like from the DW.pup) to try to copy and
> modify to use with my existing site.
>
> I have Commerce Server on a Windows 2000 server machine and SQL 2000 and
> Analysis Services on a separate SQL Server machine.
>
> I would think there would be a DTS package or something that would you could
> manually run to that would create the Olap Database.
>
> I looked in the c:\pup.log file and it says that it creates a
> c:\commerceolap.log file on creation of Cubes but the log file never is
> created.
>
> Any help I could get would greatly appreciated.
>
> Thank you.
>
> Mark
>
> "Nikola" wrote:
>
| |
| markpisc 2004-10-15, 9:11 pm |
| Hi Nikola,
I didn't get it figured out. Since this was our first (Alpha)
development/test server for Commerce Server I just rebuilt the box, put the
SQL Server, Analysis Server, and Commerce Server on the same test machine. I
unpacked the blanksite and so far everything seems to be working. I am going
to put our development .pup file on tomorrow and see what happens.
If that works I will begin to set up the 2nd Test (Beta) solution putting
SQL, Analysis, and Commerce Server/Web Server on separate machines.
My guess is that there is some kind of permisssion problem but I couldn't
figure out what it was.
I did read somewhere that Analysis server does not work well across domains
so you may have to use the same domain\user that you use on Commerce Server
to access the Analysis Server. I thought I had mine set up that way but it
still didn't work.
Good Luck! I'll let you know if I come across anything else.
"Nikola" wrote:
[vbcol=seagreen]
> Hi Mark,
>
> I haven't had any luck with this issue yet, it's been quite a while now.
>
> The sample Analysis Server DBs with Cubes and Shared Dimensions I have are
> from a couple of sample sites I installed - Retail2000 and FourthCoffee, the
> DW.pup didn't create any.
>
> I really hope that we can find a solution for this.
>
> Regards,
>
> Nikola
>
> "markpisc" wrote:
>
|
|
|
|
|