meaning of paused status

What is the meaning of the "paused" status of a catalog? What is still
working and what isn't?
Thanks.
It could mean you are on battery power, low disk space, low memory. Use the
gatherer logs to interpret further.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"muley" <muley@.discussions.microsoft.com> wrote in message
news:AFB63352-B8E8-4AFC-861A-5BE481D6338C@.microsoft.com...
> What is the meaning of the "paused" status of a catalog? What is still
> working and what isn't?
> Thanks.
|||That helps a little. What I'm looking for is this: if the catalog is paused,
what is not running in the catalog? Are the indexes still useable, etc.
Can you point me to some documentation on the meaning of all the catalog
statuses? I've looked at all the microsoft documentation I can find and some
we searches, but no luck.
Thanks.
"Hilary Cotter" wrote:

> It could mean you are on battery power, low disk space, low memory. Use the
> gatherer logs to interpret further.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "muley" <muley@.discussions.microsoft.com> wrote in message
> news:AFB63352-B8E8-4AFC-861A-5BE481D6338C@.microsoft.com...
>
>
|||You can still query when the indexing process is paused; you just won't be
able to index new content.
Regarding the status - does this help?
http://msdn.microsoft.com/library/de...fa-fz_7x15.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"muley" <muley@.discussions.microsoft.com> wrote in message
news:7BF45FB8-92B5-44C1-8913-B55777EE0F4C@.microsoft.com...
> That helps a little. What I'm looking for is this: if the catalog is
paused,
> what is not running in the catalog? Are the indexes still useable, etc.
> Can you point me to some documentation on the meaning of all the catalog
> statuses? I've looked at all the microsoft documentation I can find and
some[vbcol=seagreen]
> we searches, but no luck.
> Thanks.
>
> "Hilary Cotter" wrote:
the[vbcol=seagreen]
|||The link you gave me below is the only info I can find on the the statuses,
and it only lists what they are, not their meaning and what special
conditions are in effect when the catalog is in these states (like indexing
stopped, indexes not available, etc.).
"Hilary Cotter" wrote:

> You can still query when the indexing process is paused; you just won't be
> able to index new content.
> Regarding the status - does this help?
> http://msdn.microsoft.com/library/de...fa-fz_7x15.asp
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "muley" <muley@.discussions.microsoft.com> wrote in message
> news:7BF45FB8-92B5-44C1-8913-B55777EE0F4C@.microsoft.com...
> paused,
> some
> the
>
>
|||I have change-tracking background index update running. When I insert new
records into the table, the catalog status changes from "change tracking" to
"paused", back and forth several times, while the ~20k rows are being
inserted.
Are all the inserted records being indexed?
Thanks for the help.
"Hilary Cotter" wrote:

> You can still query when the indexing process is paused; you just won't be
> able to index new content.
> Regarding the status - does this help?
> http://msdn.microsoft.com/library/de...fa-fz_7x15.asp
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "muley" <muley@.discussions.microsoft.com> wrote in message
> news:7BF45FB8-92B5-44C1-8913-B55777EE0F4C@.microsoft.com...
> paused,
> some
> the
>
>

MDX Sub Select ?

All,

I'm using SSAS 2005 and trying to achive the foll

For a given day, find all trades that has the status as Open, Cancelled and get the correspoding TradeGroup associated to it.

Now, list all trades that falls into the above TradeGroup list irrespective of their status.

I have the foll dimensions : TradeStatus, Trade, TradeGroup , Date

I'm trying to acheive the above in a single MDX to be used in SSRS. Any idea?

Code Snippet

SELECT NON EMPTY {
[Measures].[Value]
} ON 0,
NON EMPTY
(

[TradeStatus].[TradeStatus].[Name],
[TradeGroup].[TradeGroup].[Name],

[Trade].[Trade Code].[Trade Code]
[Calendar].[Date].[Date].&[2007-08-02]
) ON 1
FROM MyCube

Any help is much appreciated.

Thanks in advance,

Cheers,

Arun

Code Snippet

SELECT NON EMPTY {
[Measures].[Value]
} ON 0,
NonEmpty

([Trade].[Trade Code].[Trade Code],

NonEmpty([TradeGroup].[TradeGroup].[Name],

{[TradeStatus].[TradeStatus].[Open],

[TradeStatus].[TradeStatus].[Cancelled]})

) ON 1
FROM MyCube

where [Calendar].[Date].[Date].&[2007-08-02]

|||

Hi Deepak,

Sorry, if I wasnt clear.

I need to display all trades from TradeGroup that has got Open and Cancelled trades. i.e. similar to the below Pseudo Code

Code Snippet

Select Trade, TradeStatus, TradeGroup

from MyCube

Where TradeGroup in (Select TradeGroup from MyCube Where Exists TradeStatus in ('Open', 'Cancelled') )

Thanks,

Arun

|||

Hi Arun,

What did the query I provided return - versus what you wanted? Your pesudo-code seems to be SQL-based; so if you could explain the fact table/measure group mapping in the cube, and the desired layout of the query results, that would help.

|||It works fine.. Thanks...

MDX Query

Hi,

I am having a query like this

SELECT NON EMPTY { [Measures].[Check Status],

[Measures].[Payment Amount], [Measures].[Check Type] }

ON COLUMNS, NON EMPTY

{ ([Activity].[Activity Identity].[Activity Identity].ALLMEMBERS *

[Activity].[Activity Description].[Activity Description].ALLMEMBERS

* [Faculty].[Faculty Name].[Faculty Name].ALLMEMBERS ) }

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM [cubActivity]

CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE,

FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Now i want to add a filter condition for this.

Where [Measures].[Payment Amount] > 4500 and [Measures].[Check Type] = 1

how to add and where to add this line the above MDX query

Can you please help me

Thanks

Dinesh

Something like the following might work

SELECT NON EMPTY { [Measures].[Check Status],

[Measures].[Payment Amount], [Measures].[Check Type] }

ON COLUMNS, NON EMPTY

FILTER({ ([Activity].[Activity Identity].[Activity Identity].ALLMEMBERS *

[Activity].[Activity Description].[Activity Description].ALLMEMBERS

* [Faculty].[Faculty Name].[Faculty Name].ALLMEMBERS ) }

, [Measures].[Payment Amount] > 4500 and [Measures].[Check Type] = 1)

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM [cubActivity]

CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE,

FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS