|
Home > Archive > Business Desk > July 2004 > Packing up sites - Custom Cubes
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 |
Packing up sites - Custom Cubes
|
|
| Darren Gillie 2004-07-02, 9:10 pm |
| I have another queston, is it possible to copy over custom cubes in the Analysis Server from one server to another? We have CS2002 Std on one server running a couple of sites and we have built a new server with CS2002 Ent Ed, where I would like to set th
em up, the problem I get is when I pack the sites up it doesn't pick up the custom cubes we use for reporting. I have backed the db up by right clicking on the dw name in the Analysis Server part and choose archive database, but when I restore the db over
the top of the deployed packed site, it does include the custom cubes, but the site will not import new web logs, it just hangs or crashes out of the application.
| |
| Brian Blum [MSFT] 2004-07-02, 9:10 pm |
| The packaging of a site does not pick up Datawarehouse changes made to
either SQL or OLAP. You have to re-apply the changes after unpacking the
new site. When archiving the cubes, did you follow the instructions in the
BOL section 'Moving the Analysis Database'?
--------------------
Thread-Topic: Packing up sites - Custom Cubes
thread-index: AcRgPJbEujcQMnQTSUOW04AQzoamYA==
X-WBNR-Posting-Host: 193.130.234.15
From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
<DarrenGillie@discussions.microsoft.com>
Subject: Packing up sites - Custom Cubes
Date: Fri, 2 Jul 2004 06:58:01 -0700
Lines: 1
Message-ID: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@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.businessdesk
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.businessdesk:6270
X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
I have another queston, is it possible to copy over custom cubes in the
Analysis Server from one server to another? We have CS2002 Std on one
server running a couple of sites and we have built a new server with CS2002
Ent Ed, where I would like to set them up, the problem I get is when I pack
the sites up it doesn't pick up the custom cubes we use for reporting. I
have backed the db up by right clicking on the dw name in the Analysis
Server part and choose archive database, but when I restore the db over the
top of the deployed packed site, it does include the custom cubes, but the
site will not import new web logs, it just hangs or crashes out of the
application.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
| |
| Darren Gillie 2004-07-05, 7:48 am |
| Brian,
Thanks for your reply.
When I re-apply the achive I my exsisting DTS import and conversion jobs fail or crash.
BOL section??? When I archive the cube it was just by right clicking on the Analsis Server db and choosing Archive. Is there a way of archiving cubes on thier own?
Darren
"Brian Blum [MSFT]" wrote:
> The packaging of a site does not pick up Datawarehouse changes made to
> either SQL or OLAP. You have to re-apply the changes after unpacking the
> new site. When archiving the cubes, did you follow the instructions in the
> BOL section 'Moving the Analysis Database'?
> --------------------
> Thread-Topic: Packing up sites - Custom Cubes
> thread-index: AcRgPJbEujcQMnQTSUOW04AQzoamYA==
> X-WBNR-Posting-Host: 193.130.234.15
> From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
> <DarrenGillie@discussions.microsoft.com>
> Subject: Packing up sites - Custom Cubes
> Date: Fri, 2 Jul 2004 06:58:01 -0700
> Lines: 1
> Message-ID: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@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.businessdesk
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.businessdesk:6270
> X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
>
> I have another queston, is it possible to copy over custom cubes in the
> Analysis Server from one server to another? We have CS2002 Std on one
> server running a couple of sites and we have built a new server with CS2002
> Ent Ed, where I would like to set them up, the problem I get is when I pack
> the sites up it doesn't pick up the custom cubes we use for reporting. I
> have backed the db up by right clicking on the dw name in the Analysis
> Server part and choose archive database, but when I restore the db over the
> top of the deployed packed site, it does include the custom cubes, but the
> site will not import new web logs, it just hangs or crashes out of the
> application.
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
| |
| David Messner [MSFT] 2004-07-09, 5:48 pm |
| Brian is out this week, but by BOL I think he means Books Online (in this
case, the CS2002 CHM Help file).
Under the topic "Moving the Contents of the Data Warehouse", you will find
the subtopic "Moving the Analysis Database".
Archive the analysis database.
Restore the analysis database into the new location.
Process the virtual cubes.
-djm
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.
--------------------
Thread-Topic: Packing up sites - Custom Cubes
thread-index: AcRihM6/REYKi0IZTtS9hH1li6RVZw==
X-WBNR-Posting-Host: 193.130.234.15
From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
<DarrenGillie@discussions.microsoft.com>
References: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@microsoft.com>
<wWEzBAGYEHA.3168@cpmsftngxa06.phx.gbl>
Subject: RE: Packing up sites - Custom Cubes
Date: Mon, 5 Jul 2004 04:40:01 -0700
Lines: 57
Message-ID: <E58963DE-1382-4D41-93AA-A390AC52B4CF@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.businessdesk
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.businessdesk:6274
X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
Brian,
Thanks for your reply.
When I re-apply the achive I my exsisting DTS import and conversion jobs
fail or crash.
BOL section??? When I archive the cube it was just by right clicking on
the Analsis Server db and choosing Archive. Is there a way of archiving
cubes on thier own?
Darren
"Brian Blum [MSFT]" wrote:
> The packaging of a site does not pick up Datawarehouse changes made to
> either SQL or OLAP. You have to re-apply the changes after unpacking the
> new site. When archiving the cubes, did you follow the instructions in
the
> BOL section 'Moving the Analysis Database'?
> --------------------
> Thread-Topic: Packing up sites - Custom Cubes
> thread-index: AcRgPJbEujcQMnQTSUOW04AQzoamYA==
> X-WBNR-Posting-Host: 193.130.234.15
> From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
> <DarrenGillie@discussions.microsoft.com>
> Subject: Packing up sites - Custom Cubes
> Date: Fri, 2 Jul 2004 06:58:01 -0700
> Lines: 1
> Message-ID: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@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.businessdesk
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: cpmsftngxa06.phx.gbl
microsoft.public.commerceserver.businessdesk:6270
> X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
>
> I have another queston, is it possible to copy over custom cubes in the
> Analysis Server from one server to another? We have CS2002 Std on one
> server running a couple of sites and we have built a new server with
CS2002
> Ent Ed, where I would like to set them up, the problem I get is when I
pack
> the sites up it doesn't pick up the custom cubes we use for reporting. I
> have backed the db up by right clicking on the dw name in the Analysis
> Server part and choose archive database, but when I restore the db over
the
> top of the deployed packed site, it does include the custom cubes, but
the
> site will not import new web logs, it just hangs or crashes out of the
> application.
>
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBusiness Server Team
| |
| Darren Gillie 2004-07-12, 2:48 am |
| Thanks David,
Yes, I had followed these instructions to restore the database, and have now imported the custom cubes across.
One more question, is there a way to extract a custom cube from one site and import it into another site? I've tried the copy option but I get 'Same datasource name but some of the connection string properties are different'.
"David Messner [MSFT]" wrote:
> Brian is out this week, but by BOL I think he means Books Online (in this
> case, the CS2002 CHM Help file).
>
> Under the topic "Moving the Contents of the Data Warehouse", you will find
> the subtopic "Moving the Analysis Database".
>
> Archive the analysis database.
> Restore the analysis database into the new location.
> Process the virtual cubes.
>
> -djm
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use. © 2004 Microsoft Corporation. All rights
> reserved.
>
> --------------------
> Thread-Topic: Packing up sites - Custom Cubes
> thread-index: AcRihM6/REYKi0IZTtS9hH1li6RVZw==
> X-WBNR-Posting-Host: 193.130.234.15
> From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
> <DarrenGillie@discussions.microsoft.com>
> References: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@microsoft.com>
> <wWEzBAGYEHA.3168@cpmsftngxa06.phx.gbl>
> Subject: RE: Packing up sites - Custom Cubes
> Date: Mon, 5 Jul 2004 04:40:01 -0700
> Lines: 57
> Message-ID: <E58963DE-1382-4D41-93AA-A390AC52B4CF@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.businessdesk
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.businessdesk:6274
> X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
>
> Brian,
>
> Thanks for your reply.
>
> When I re-apply the achive I my exsisting DTS import and conversion jobs
> fail or crash.
>
> BOL section??? When I archive the cube it was just by right clicking on
> the Analsis Server db and choosing Archive. Is there a way of archiving
> cubes on thier own?
>
> Darren
>
>
> "Brian Blum [MSFT]" wrote:
>
> the
> microsoft.public.commerceserver.businessdesk:6270
> CS2002
> pack
> the
> the
> rights.
>
| |
| Brian Blum [MSFT] 2004-07-12, 5:51 pm |
| You're getting that error message because datasource names must be unique
per server. The easiest thing to do is to change the source server
datasource properties to match what you want the destination server to be
BEFORE doing the copy and paste. When the cube copy and paste is done, you
can change the source server datasource properties back to their original
values.
--------------------
Thread-Topic: Packing up sites - Custom Cubes
thread-index: AcRn5u77mDHnnlo9SSi3RGE48RRTNQ==
X-WBNR-Posting-Host: 193.130.234.15
From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
<DarrenGillie@discussions.microsoft.com>
References: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@microsoft.com>
<wWEzBAGYEHA.3168@cpmsftngxa06.phx.gbl>
<E58963DE-1382-4D41-93AA-A390AC52B4CF@microsoft.com>
<fEoJRtgZEHA.3168@cpmsftngxa06.phx.gbl>
Subject: RE: Packing up sites - Custom Cubes
Date: Mon, 12 Jul 2004 01:05:02 -0700
Lines: 121
Message-ID: <A6B30119-6E1E-4407-84BB-B6C29155A857@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
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.businessdesk
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.businessdesk:6290
X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
Thanks David,
Yes, I had followed these instructions to restore the database, and have
now imported the custom cubes across.
One more question, is there a way to extract a custom cube from one site
and import it into another site? I've tried the copy option but I get
'Same datasource name but some of the connection string properties are
different'.
"David Messner [MSFT]" wrote:
> Brian is out this week, but by BOL I think he means Books Online (in this
> case, the CS2002 CHM Help file).
>
> Under the topic "Moving the Contents of the Data Warehouse", you will
find
> the subtopic "Moving the Analysis Database".
>
> Archive the analysis database.
> Restore the analysis database into the new location.
> Process the virtual cubes.
>
> -djm
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. © 2004 Microsoft Corporation. All
rights
> reserved.
>
> --------------------
> Thread-Topic: Packing up sites - Custom Cubes
> thread-index: AcRihM6/REYKi0IZTtS9hH1li6RVZw==
> X-WBNR-Posting-Host: 193.130.234.15
> From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
> <DarrenGillie@discussions.microsoft.com>
> References: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@microsoft.com>
> <wWEzBAGYEHA.3168@cpmsftngxa06.phx.gbl>
> Subject: RE: Packing up sites - Custom Cubes
> Date: Mon, 5 Jul 2004 04:40:01 -0700
> Lines: 57
> Message-ID: <E58963DE-1382-4D41-93AA-A390AC52B4CF@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.businessdesk
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: cpmsftngxa06.phx.gbl
microsoft.public.commerceserver.businessdesk:6274
> X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
>
> Brian,
>
> Thanks for your reply.
>
> When I re-apply the achive I my exsisting DTS import and conversion jobs
> fail or crash.
>
> BOL section??? When I archive the cube it was just by right clicking on
> the Analsis Server db and choosing Archive. Is there a way of archiving
> cubes on thier own?
>
> Darren
>
>
> "Brian Blum [MSFT]" wrote:
>
the[vbcol=seagreen]
> the
> microsoft.public.commerceserver.businessdesk:6270
> CS2002
> pack
I[vbcol=seagreen]
> the
> the
> rights.
>
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
| |
| Darren Gillie 2004-07-13, 7:50 am |
| Thanks, I have managed to copy and paste the cube.
"Brian Blum [MSFT]" wrote:
> You're getting that error message because datasource names must be unique
> per server. The easiest thing to do is to change the source server
> datasource properties to match what you want the destination server to be
> BEFORE doing the copy and paste. When the cube copy and paste is done, you
> can change the source server datasource properties back to their original
> values.
> --------------------
> Thread-Topic: Packing up sites - Custom Cubes
> thread-index: AcRn5u77mDHnnlo9SSi3RGE48RRTNQ==
> X-WBNR-Posting-Host: 193.130.234.15
> From: "=?Utf-8?B?RGFycmVuIEdpbGxpZQ==?="
> <DarrenGillie@discussions.microsoft.com>
> References: <ED87192D-33D4-4320-8CD7-99A9BE6E58ED@microsoft.com>
> <wWEzBAGYEHA.3168@cpmsftngxa06.phx.gbl>
> <E58963DE-1382-4D41-93AA-A390AC52B4CF@microsoft.com>
> <fEoJRtgZEHA.3168@cpmsftngxa06.phx.gbl>
> Subject: RE: Packing up sites - Custom Cubes
> Date: Mon, 12 Jul 2004 01:05:02 -0700
> Lines: 121
> Message-ID: <A6B30119-6E1E-4407-84BB-B6C29155A857@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 8bit
> 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.businessdesk
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
> Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.businessdesk:6290
> X-Tomcat-NG: microsoft.public.commerceserver.businessdesk
>
> Thanks David,
>
> Yes, I had followed these instructions to restore the database, and have
> now imported the custom cubes across.
>
> One more question, is there a way to extract a custom cube from one site
> and import it into another site? I've tried the copy option but I get
> 'Same datasource name but some of the connection string properties are
> different'.
>
>
>
> "David Messner [MSFT]" wrote:
>
> find
> rights.
> rights
> microsoft.public.commerceserver.businessdesk:6274
> the
> I
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
|
|
|
|
|