Home > Archive > MS SQL Server OLAP > November 2005 > How tu unprocess Cube und Dimensions in AS2K???









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 How tu unprocess Cube und Dimensions in AS2K???
Vladimir Chtepa

2005-11-24, 9:23 am

Subj,

Vladimir Chtepa


MC

2005-11-24, 11:23 am

What do you mean by unprocess? What are you trying to do?

MC


"Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> wrote in message
news:ubBbaTQ8FHA.1276@TK2MSFTNGP09.phx.gbl...
> Subj,
>
> Vladimir Chtepa
>



James

2005-11-24, 11:23 am

copy and paste the cube / database

"Vladimir Chtepa" wrote:

> Subj,
>
> Vladimir Chtepa
>
>
>

Vladimir Chtepa

2005-11-24, 8:23 pm

There is this processing option in the AS2K5. I want the same under AS2K.

"MC" <marko_culo#@#yahoo#.#com#> schrieb im Newsbeitrag
news:OD7nrsQ8FHA.3976@TK2MSFTNGP15.phx.gbl...
> What do you mean by unprocess? What are you trying to do?
>
> MC
>
>
> "Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> wrote in message
> news:ubBbaTQ8FHA.1276@TK2MSFTNGP09.phx.gbl...
>
>



Vladimir Chtepa

2005-11-24, 8:23 pm

As I exepected - this is a last possible option is the only possible one.
:-)

"James" <aa1948@nospam.nospam> schrieb im Newsbeitrag
news:BCA3891A-D852-4271-A76E- 3A0E371CFE82@microso
ft.com...[color=darkred]
> copy and paste the cube / database
>
> "Vladimir Chtepa" wrote:
>


Dave Wickert [MSFT]

2005-11-25, 3:23 am

There is no specific function. You have to trick the system by requesting
something which has the desired "unprocess" effect. My favorite approach is
to just do a full process of a non-changing dimension used by the cube.
Bingo. Anything which uses that dimension is now unprocessed.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Vladimir Chtepa" <vc.nospam@diacom-systemhaus.nospam.de> wrote in message
news:uSs$S8T8FHA.2816@tk2msftngp13.phx.gbl...
> There is this processing option in the AS2K5. I want the same under AS2K.
>
> "MC" <marko_culo#@#yahoo#.#com#> schrieb im Newsbeitrag
> news:OD7nrsQ8FHA.3976@TK2MSFTNGP15.phx.gbl...
>
>



Darren Gosbell

2005-11-25, 3:23 am

If you don't mind a short outage you can do the following:

1) stop the AS service
2) delete the Cube folder and dimension files from the data folder
3) restart the AS service

To make the outage as short as possible you could do all this in a
single command file.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <eaWVI9T8FHA.1292@tk2msftngp13.phx.gbl>, vc.nospam@diacom-
systemhaus.nospam.de says...
> As I exepected - this is a last possible option is the only possible one.
> :-)
>
> "James" <aa1948@nospam.nospam> schrieb im Newsbeitrag
> news:BCA3891A-D852-4271-A76E- 3A0E371CFE82@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com