Determine status of processing cube

From C# I need to determine if a cube is currently processing. We are trying to avoid running MDX against a cube while in the act - it results in an error message to our users.

Does anybody know of a way to do this? Maybe with AMO?

Thanks in advance,

John

Hello John,

There is no easy way of doing this in AMO, but you could use the DISCOVER_LOCKS schema rowset to test whether there are write locks on your cube. The LOCK_STATUS and LOCK_TYPE fields returned by this discover could help you find this out.

Hope this helps,

Artur

Detecting status of snapshot agent...

Is there an easy way to determine the status/progress of the snapshot agent
for a particular merge publication?
Troy - much the same as the question for your merge agent:
sp_help_job will do it on an ad-hoc basis, but if you need to do something
as a result of the job status, you could modify this script to do it:
http://www.replicationanswers.com/Downloads/KillRunningJobs.txt
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Detecting a change in a particular field in a database

Is it possible, using VB code, to retain a user on a particular pageuntil the status of a certain field in a database is changed?
The scenario I am working on is that a person makes a reservation andhas to wait until that reservation has been accepted or rejected by theadministration.
Dim dsResv As DataSet
dsResv = objResv.DALgetResvStatus(resvId)
While (dsResv.Tables(0).Rows(0).Item("resvStatus") = "pending")
dsResv = objResv.DALgetResvStatus(resvId)
IfdsResv.Tables(0).Rows(0).Item("resvStatus") = "denied" Then
failure.Visible = True
LinkButton1.Visible = True
ElseIf dsResv.Tables(0).Rows(0).Item("resvStatus") = "reserved" Then
success.Visible = True
LinkButton1.Visible = True
End If
End While
This is how I tried to do it, but it doesnt seem to work.
Any suggestions?
If it is web application, use AJAX to send the request to the server and to get the response asynchronously without submitting the page to server.
For AJAX refer:
http://aspalliance.com/716|||Any other way??
i mean without javascripting

Details on Subscription.Status property

Hi,
I need to know all the possible values that the "Subscription.Status"
property can return ( I'm creating my own UI and all text has to be
translated into another language )
Thanks,
AntonioThis field can contain an unknown number of values. Delivery extensions are
allowed to write any value in there. The two delivery extensions that
shipped with RS (file and email) will write out Success and error messages.
The error messages alone will be numerous.
The status however should already be localized into the langue of the user
which created the subscription. Is this not sufficient?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Antonio Bruno" <AntonioBruno@.discussions.microsoft.com> wrote in message
news:CA153CAC-3246-404D-92A6-75E9839A2528@.microsoft.com...
> Hi,
> I need to know all the possible values that the "Subscription.Status"
> property can return ( I'm creating my own UI and all text has to be
> translated into another language )
> Thanks,
> Antonio|||Daniel,
Thanks for that.
I'm using the standard e-mail extension and what I really would like to have
is a way of programatically distinguish an error status from a success
status. Could it be that all error messages have the string "error" somewhere
in there?
I've decided best not to develop a new security extension (it's an Internet
app.), and I'm working my way around using the standard security and the
web-service. So all subscriptions are created by the same user via the
web-service (I have a separate table on my app. DB to know who's which).
When you say that the status will be translated into the user's language I'm
assuming that it'll be into one of the available ones in RS. Well ... my
language isn't any of those, so I would always have to translate. One thing
that might be helpfull in the future would be to have either the sources for
the resource files or some other way that would enable us to easily do the
translations ourselves in case of unsupported languages. This would also make
it easy to know all strings that an extension outputs, which would be a nice
way of solving my problem.
Anyway, your tip was very helpfull. I'll "reflector" the e-mail extension
resource file and try to figure out those values.
Thanks again,
Antonio
"Daniel Reib [MSFT]" wrote:
> This field can contain an unknown number of values. Delivery extensions are
> allowed to write any value in there. The two delivery extensions that
> shipped with RS (file and email) will write out Success and error messages.
> The error messages alone will be numerous.
> The status however should already be localized into the langue of the user
> which created the subscription. Is this not sufficient?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Antonio Bruno" <AntonioBruno@.discussions.microsoft.com> wrote in message
> news:CA153CAC-3246-404D-92A6-75E9839A2528@.microsoft.com...
> > Hi,
> >
> > I need to know all the possible values that the "Subscription.Status"
> > property can return ( I'm creating my own UI and all text has to be
> > translated into another language )
> >
> > Thanks,
> >
> > Antonio
>
>|||As a follow-up on my previous post (in case someone else needs it):
Using Lutz's Reflector on ReportingServicesLibrary.dll, the
Microsoft.ReportingServices.Library.RepLibRes.resources shows the following
keys:
New Subscription=New Subscription
SubscriptionDone=Done: {0} processed of {1} total; {2} errors.
SubscriptionError=Error: {0}
SubscriptionParametersInvalid=Subscription contains invalid parameters.
SubscriptionPending=Pending
SubscriptionProcessing=Processing: {0} processed of {1} total; {2} errors.
SubscriptionReady=Ready
I'll just parse these strings to do my translations.
Regards,
Antonio
"Daniel Reib [MSFT]" wrote:
> This field can contain an unknown number of values. Delivery extensions are
> allowed to write any value in there. The two delivery extensions that
> shipped with RS (file and email) will write out Success and error messages.
> The error messages alone will be numerous.
> The status however should already be localized into the langue of the user
> which created the subscription. Is this not sufficient?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Antonio Bruno" <AntonioBruno@.discussions.microsoft.com> wrote in message
> news:CA153CAC-3246-404D-92A6-75E9839A2528@.microsoft.com...
> > Hi,
> >
> > I need to know all the possible values that the "Subscription.Status"
> > property can return ( I'm creating my own UI and all text has to be
> > translated into another language )
> >
> > Thanks,
> >
> > Antonio
>
>|||While this will get you started. The valuable information for the error is
what is inside the {0}. This information will be in the language in which
the subscription was created. (one of the supported languages). If all you
are looking for is pass fail, then looking for error will suffice (assuming
all subscriptions are made in English). We are looking at putting a
pass/fail property on the subscription object to help in cases like this.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Antonio Bruno" <AntonioBruno@.discussions.microsoft.com> wrote in message
news:B35CCFE7-89D3-4B82-9844-367479E8FD06@.microsoft.com...
> As a follow-up on my previous post (in case someone else needs it):
> Using Lutz's Reflector on ReportingServicesLibrary.dll, the
> Microsoft.ReportingServices.Library.RepLibRes.resources shows the
> following
> keys:
> New Subscription=New Subscription
> SubscriptionDone=Done: {0} processed of {1} total; {2} errors.
> SubscriptionError=Error: {0}
> SubscriptionParametersInvalid=Subscription contains invalid parameters.
> SubscriptionPending=Pending
> SubscriptionProcessing=Processing: {0} processed of {1} total; {2} errors.
> SubscriptionReady=Ready
> I'll just parse these strings to do my translations.
> Regards,
> Antonio
>
> "Daniel Reib [MSFT]" wrote:
>> This field can contain an unknown number of values. Delivery extensions
>> are
>> allowed to write any value in there. The two delivery extensions that
>> shipped with RS (file and email) will write out Success and error
>> messages.
>> The error messages alone will be numerous.
>> The status however should already be localized into the langue of the
>> user
>> which created the subscription. Is this not sufficient?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Antonio Bruno" <AntonioBruno@.discussions.microsoft.com> wrote in message
>> news:CA153CAC-3246-404D-92A6-75E9839A2528@.microsoft.com...
>> > Hi,
>> >
>> > I need to know all the possible values that the "Subscription.Status"
>> > property can return ( I'm creating my own UI and all text has to be
>> > translated into another language )
>> >
>> > Thanks,
>> >
>> > Antonio
>>

Design question related to Grouping

Hello,

I am using SQL 2005 Reporting Services to create a user status report. Each page of the report will contain information about 1 user.

On a single page, there are 4 different views of the data (pulling from different tables). Ideally, I would like to group the data (by user for each page, then by category for each of the 4 views on the page). I grouped by user, and the separate pages came out fine. But attempting to group by category, I found that the grouping applies to all the data...and I only want to group a subset of the data.

Is this possible? Will I need to nest select statements to make it happen? Is there a better way to approach this?

Go easy on me...I'm new to this.

Thanks,
Davidi think what your looking for is an outer join.
select * from table1 1
left outer join table2 2 on 1.column = 2.column