Re: Processing Cubes

#1

Are you able to process Foodmart?

tom @ the domain below
www.tomchester.net

"mimi" <altrena.williams (AT) globalpay (DOT) com> wrote

Quote:

Hi all,

I have one fact table and only two dimensions. When I
process the cube, it will hang up every time. There are
no loops or incorrect joins.

Any suggestions??

#2

Yes, I can.

Quote:

-----Original Message-----
Are you able to process Foodmart?

tom @ the domain below
www.tomchester.net

"mimi" <altrena.williams (AT) globalpay (DOT) com> wrote in message
news:071e01c3722c$7815fbe0$a001280a (AT) phx (DOT) gbl...
Hi all,

I have one fact table and only two dimensions. When I
process the cube, it will hang up every time. There are
no loops or incorrect joins.

Any suggestions??

.

#3

Ooh, I would really like to know the answer to this question as well.
We were just discussing the frustration of not getting errors even when
the job failed miserably lastnight. We did figure out why it was
failing (our bad), but had to go into the history logs to research.
Hopefully there is a way to add this functionality to the XMLA?

ERS Developer wrote:

Quote:

Hi,

Currently I am using XMLA commands in a SQL Job to process the cubes. If
some error occurs during the process the cube rolls back to its intial state
and
the sql job returns no error.

How can we send alerts to DBA when the cube process fails.

Thanks
S

#4

do you use the integrated SQL Agent / job / task which execute XMLA
commands?
or do you use the ASCMD utility ?

"ERS Developer" <ERSDeveloper (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,
What I have got so far is. if we use the error configuration in the xmla
commands it logs to the job history.

But it doesn't fail the SQL job. It always says step succeded and no
alerts
goes out.

/
ERS

"susansandster (AT) gmail (DOT) com" wrote:

Ooh, I would really like to know the answer to this question as well.
We were just discussing the frustration of not getting errors even when
the job failed miserably lastnight. We did figure out why it was
failing (our bad), but had to go into the history logs to research.
Hopefully there is a way to add this functionality to the XMLA?

ERS Developer wrote:
Hi,

Currently I am using XMLA commands in a SQL Job to process the cubes.
If
some error occurs during the process the cube rolls back to its intial
state
and
the sql job returns no error.

How can we send alerts to DBA when the cube process fails.

Thanks
S

#5

I'm not sure how the integrated task in the agent handle errors.
the ascmd utility return 1 if there is a failure and 0 if not.
so you can easely know if there is a failure or not in the XML/A execution
with this utility.

"ERS Developer" <ERSDeveloper (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I am using the regular SQL Job and in the job step I choose the type
"SQL Server Analysis Services Command" and in the command window I put the
below XMLA commands.

Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
ErrorConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
KeyNotFound>ReportAndStop</KeyNotFound
NullKeyConvertedToUnknown>IgnoreError</NullKeyConvertedToUnknown
NullKeyNotAllowed>IgnoreError</NullKeyNotAllowed
/ErrorConfiguration
Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
Object
DatabaseID>Homeroom Analytics1</DatabaseID
/Object
Type>ProcessFull</Type
WriteBackTableCreation>UseExisting</WriteBackTableCreation
/Process
/Batch

/
ERS

"JÃ©jÃ©" wrote:

do you use the integrated SQL Agent / job / task which execute XMLA
commands?
or do you use the ASCMD utility ?

"ERS Developer" <ERSDeveloper (AT) discussions (DOT) microsoft.com> wrote in message
news:BAB99B95-8EAD-47D5-95E5-CE35232C1F84 (AT) microsoft (DOT) com...
Hi,
What I have got so far is. if we use the error configuration in the
xmla
commands it logs to the job history.

But it doesn't fail the SQL job. It always says step succeded and no
alerts
goes out.

/
ERS

"susansandster (AT) gmail (DOT) com" wrote:

Ooh, I would really like to know the answer to this question as well.
We were just discussing the frustration of not getting errors even
when
the job failed miserably lastnight. We did figure out why it was
failing (our bad), but had to go into the history logs to research.
Hopefully there is a way to add this functionality to the XMLA?

ERS Developer wrote:
Hi,

Currently I am using XMLA commands in a SQL Job to process the
cubes.
If
some error occurs during the process the cube rolls back to its
intial
state
and
the sql job returns no error.

How can we send alerts to DBA when the cube process fails.

Thanks
S

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Processing Cubes

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Processing Cubes - 09-03-2003 , 11:12 AM

Re: Processing Cubes - 09-10-2003 , 11:40 AM

Re: Processing Cubes - 01-17-2007 , 12:14 PM

Re: Processing Cubes - 01-17-2007 , 12:29 PM

Re: Processing Cubes - 01-18-2007 , 07:33 AM