BusinessObjects Board

Need Help-

building semantic layer
#1

Howdy,
I am a beginner and need some help from you guys.
Database: SQl Server 2000
BO: 6.1b

  1. How the truncate the time part in a Date Object. The object(date datatype) is used as predefined prompt filter(list of values enabled) When runing the report, the value comes like
    ex: 12/10/2004 12:00:00.
    i just want the date part.

  2. this is tricky.how to create a look up table?
    I got 2 tables

table Field1 Field2

tbl1 xanum CSid
tbl2 ccid —

A object has be created in BO for CCID, but i want to lookup tbl1 and display corresponding values in CSID column

The query/relationship is :

select csid
from tbl1 INNER JOIN tbl2 ON
convert(int,substring(tbl2.ccid,6,9)) = tbl1.xanum

I know its more confusing, but any help would be much appreciated…

Tracey

Tracey_au (BOB member since 2004-12-07)

#2

I think you should just change the object format. Right click the object in the designer and select “Object Format”. Select Date and change the format to one that doesnt have time.

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

#3

I dont know if I got what you are looking for, but you can create an object to do convert(int,substring(tbl2.ccid,6,9)), and then join with tbl1.xanum using that object. That would give you the same query.

I hope this helps.

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

#4

Tracey,

Can I suggest that you edit your original post in this topic, and give it a more meaningful subject? You will find that you will get more help that way. :mrgreen:

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#5

This question is covered in the Designer FAQ… the actual topic referenced from the Designer FAQ entry is here.

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