BusinessObjects Board

Unable to create a sysdate object @ universe level

building semantic layer
#1

Hi,

When I try to create a object with sysdate in the select clause, it is giving me error.
Error:
Parse Failed :DBD ora 00903 , invalid table name.

My req is i need to filter a webi report using current year and month, that is why i wanted to create a object at universe level.

please suggest.

Thanks,

swamy82 (BOB member since 2007-05-08)

#2

Hi,

An object based on sysdate that does not reference any real table will not parse. However, it can be used without any problems with any other normal universe objects in a query panel.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

This topic is also covered in the Designer FAQ. :wink:

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

#4

Hi,

I did try to do that, but still it is not working.

The parse fails, even then I give Ok I am not able to create that object.

Thanks,

swamy82 (BOB member since 2007-05-08)

#5

What’s the exact definition of the object?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#6

Hi,

I defined it to be a Dimension object , type was date, in the select stmt I choose the systdate from the date function list.

swamy82 (BOB member since 2007-05-08)

#7

Shouldn’t it be

sysdate

if you use Oracle database?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#8

Yes…typo from my side…I did use sysdate from the function list.

swamy82 (BOB member since 2007-05-08)

#9

Then it should be possible to save the object and use it with any other object.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#10

PFA, the screens of how I created this object.

My oracle db is 11g , I use BO XI R2 10 g drivers to connect to that DB, will that matter,I feel that should be something to do with the drivers compatiablity.

Please comment.
Sysdate_object_error.doc (59.0 KB)

swamy82 (BOB member since 2007-05-08)

#11

I already mentioned that such object will not parse. But, you can save it and use it with any other object in a query. Have you tried that? :roll_eyes:

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#12

This covers it all:

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

#13

Yes,I did try to save with the parse error, it is not allowing me to go ahead, that is the issue I am talking abt.

swamy82 (BOB member since 2007-05-08)

#14

Dave, I completely understand that even if i get a parse error, I can go ahead save the object, but in this case it is not allowing me to save.

swamy82 (BOB member since 2007-05-08)

#15

Don’t parse, just save it.

What sort of response are you getting? I’ve never seen this behavior, where Designer would refuse to save an object because of a parse error.

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

#16

Yea…I did try that, the error I get is :

Exception DBD ,ORA 00903:INVALID Table name.

I just tired to save . did not parse it at all.

Thanks.,

swamy82 (BOB member since 2007-05-08)

#17

Create a new object.

Call it Today

In the select box type
trunc(sysdate)

Click OK at the bottom.

Save and Export your universe.

Use the Today object in a query with other objects.

Report back.

:+1:

#18

Something just occurred to me… you probably have automatic parse turned on. Turn that off and you should be fine. It’s under “Tools” and then “Options” and on the “General” tab.

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

#19

Great Thanks Dave…that worked…I had the automatic parse option disabled.

Thanks, that worked…I really appreciate your help.

Rgds,

swamy82 (BOB member since 2007-05-08)

#20

Hi,

You can link the object to SYS.Dual table which is a dummy table in Oracle and then ue SysDate in Object Definitions to avoid parse error .

sagar10 (BOB member since 2010-11-11)