sysdate problem

building semantic layer
1

i need to create sysdate in universes level

class :object:sysdate

then i link with one table
it working fine
but when i cheked with another tables…
its not working…
can u tell me solution…

nsai (BOB member since 2007-03-27)

2

Please tell us what “its not working” means … error message, unexpected behavior?

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

3

yes it showing error Here
cartesion product

can u please tell me solution.

cheers
Nsai

nsai (BOB member since 2007-03-27)

4

Check the joins. You might not be linking them properly.

I had the same problem too when I cross checked my joins I was linking a charecter feild to numeric feild.

Cheers…Ramala

ramala (BOB member since 2007-07-13)

5

Hi ,
just i have 5 tables okk
i dint join any table
just i need sysdate in universe level

i create object and i link point to one table
when i run reports its showing fine sysdate
but when i drag object from another table
it showing error cartesion product.

cheers
Nsai

nsai (BOB member since 2007-03-27)

6

Are you creating a join or not between the two table you are pulling data from?

Without linking the tables properly I dont think you will get appropriate data.

ramala (BOB member since 2007-07-13)

7

I would imagine that is becuase you have not defined any joins between your tables…?

Mak 1 :uk: (BOB member since 2005-01-06)

8

sysdate objects should not be related to any table, therefore they will avoid any cartesian warning when used with different tables. The object will not parse, but will function on a report. I believe this is covered in the FAQ.

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

9

You try something like this if you would like to use with database objects without an error

select table_name.date_feild
from table_name where table_name=sysdate()

this should work if joined properly.

ramala (BOB member since 2007-07-13)