Check Interrupted by User

building semantic layer
1

While parsing Objects in the Universe, i am getting an error “Check Interrupted by User”.

When we go to that particular object, and check the Query behind it, prompt function has been used here, which is the cause of this Interruption.
When we parse the individual obects , we get an error like “Invalid Definition”.

I googled , and found that
In Designer, when creating an OLAP universe on an MSAS data source, if
you parse an object definition containing a dynamic element (for example,
@PROMPT), the following error occurs:
“Parse Failed” Invalid definition
The query runs correctly in Web Intelligence.

Can anyone please suggest , how can i proceed futher to perform the parsing of objects without any interruption , in the Universe?

ANITA SONTHALIA (BOB member since 2009-07-30)

2

What’s the object SQL? Are you using @prompt, and is your @prompt syntax correct?

SteveBickerton :canada: (BOB member since 2002-08-15)

3

Is this object based on a derived table? If so, check the syntax for that table and make sure it’s still valid.

Dave Rathbun :us: (BOB member since 2002-06-06)

4

There are many SQLs in which I am facing this issue.
I am pasting below one such scenario :

SELECT a,b,c,d
FROM
t1,t2

WHERE t1.col1 = t2.col2
AND @Prompt(‘FiscalMonth’,‘N’,) BETWEEN t1.FROM_ABS_MONTH AND
t1.TO_ABS_MONTH
AND t1.ID IN @Prompt(‘AllSalesSpecialtiesIDs’,‘N’,multi,free)
AND @Prompt(‘FiscalMonth’,‘N’,) BETWEEN t2.FROM_ABS_MONTH AND
t2.TO_ABS_MONTH

These queries are working fine from past many years, when a report is being created using these objects.
But now as per BOSS compliance, I am planning to remove any integrity issues related with the Universe.
But am stuck here, due to this issue :frowning: Please help . Thanks

ANITA SONTHALIA (BOB member since 2009-07-30)

5

AND
(@Prompt(‘FiscalMonth’,‘N’,) BETWEEN t1.FROM_ABS_MONTH AND
t1.TO_ABS_MONTH

This would translate to:
12 between t1.FROM_ABS_MONTH AND t1.TO_ABS_MONTH

Can you try this in your derived table? This is kinda a strange way to do a between statement…you could change this to be:

t1.FROM_ABS_MONTH >= (@Prompt(‘FiscalMonth’,‘N’,)
OR
t1.TO_ABS_MONTH<=(@Prompt(‘FiscalMonth’,‘N’,)

You would need to pay attention to your brackets to get your statement order correct as well…

SteveBickerton :canada: (BOB member since 2002-08-15)