Skip to Content
avatar image
Former Member

How do I get a list of all calender dates to use in webi?

I am using BO 4.1 Sp06,

Sql 2014.

I want to display a stock level on every business date in webi.in a chart

when there is no data for a business date, it should show data from previous date .

I don't have problem with that.

My issue is I don't have all the dates in table it will have date only if there is any transaction happens.

Basically stock level= current stock-(scheduled deposit + scheduled orders)

= A-B

here dates are coming from B, and it will have dates only if there is any scheduled deposit or order on that day else date doesn't exist in the table.

For that reason I need an object to get all the dates and then I can further will be able to filter to get business dates and all.

I don't have any table in DB to get all dates

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 08, 2017 at 07:55 AM

    have you tried with Timedim() function in webi?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am trying something like this and it gives me error

      =TimeDim([Dates]) Where (TimeDim([Dates])<>([Holiday Date]))

      I am using above but getting error #Incompatible