BusinessObjects Board

Help required for this unique requirement on date

building reports webintelligence
#1

Hello Experts

Our DB gets data for the report for weekdays only.

Client requirement is to create a report that has records from Mon-Sun with weekend being populated with Friday’s business day’s figures.

DB Data

Day Volume
Mon 10
Tue 20
Wed 20
Thu 20
Fri 10

BO should show

Day Volume
Mon 10
Tue 20
Wed 20
Thu 20
Fri 10
Sat 10
Sun 10

Any suggestions on how we could achieve this is truly appreciated.

hesh99 (BOB member since 2009-06-30)

#2

Any advice ? Thanks!!

hesh99 (BOB member since 2009-06-30)

#3

You can force the other days in with something along these lines…

Nick Daniels :uk: (BOB member since 2002-08-15)

#4

Hi Nick

Thanks for the suggestion. I went through it.

But unfortunately it doesn’t help for me as the weekend dates are not available in the database at all. Database has only Mon-Fri data for any given table but client expects report to show for Mon-Sun with Fridays data copied over for Saturday and Sunday.

hesh99 (BOB member since 2009-06-30)

#5

Would the TimeDim function help?

mikeil (BOB member since 2015-02-18)

#6

Wow. That solution makes me happy and sad at the same time.
It solves the exact requirement I’ve.
But the sad bit is I don’t have Timedim available in my BO version. I’m in BO 12.3.2.

Any other work around solution that can match the functionality of timedim ?

Thanks!!

hesh99 (BOB member since 2009-06-30)

#7

Strange - I’m only on 12.1.0 yet I have it.

Perhaps a union query with 3 legs, picking up Friday’s data in the second leg and interpreting it as Saturday; and again in the third leg, interpreting it as Sunday.

mikeil (BOB member since 2015-02-18)

#8

Thanks so much mikeil. Your idea worked!!

hesh99 (BOB member since 2009-06-30)