cancel
Showing results for 
Search instead for 
Did you mean: 

Calendar usage in BO XI R3 universe

Former Member
0 Kudos

Hi all,

In Business objects XI R3.1 relational universe, there are several tables (approx 50), each having multiple date columns. There is a separate custom calendar table which includes columns like accounting weekend date, accounting monthend date, financial yearend date.

The business user wants to use the calendar table with multiple date columns. The following are the solution options we have:

- use merge dimensions option for linking the calendar dimension to the required date column

- the business users who create the report thinks that 'the merge dimension' option is not user friendly and will be difficult for many of the report creators (other business users)

- create one alias table for every date column

- creating alias table for a fixed no of date columns (for e.g. 4 different date columns) may be fine, but beyond that the complexity of the universe increases for every alias. There is a high possibility of the business users asking to include more and more date columns to be linked to calendar class.

Is there any other better/easier solution for solving this calendar issue?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Sankara,

The requirement is not clear. Could you please be more specific.

As per your description  " The business user wants to use the calendar table with multiple date columns"

what exactly this mean.

Thanks,

Pramod.

Former Member
0 Kudos

Here is an example scenario: the order table has 4 date columns - planned start date, planned end date, actual start date and actual end date. The calendar dimension has about 20 columns like accounting weekend date, accounting monthend date, financial yearend date.  The business user wants the accounting columns for each of the order date columns.

There are about 10 tables each have 2 to 4 date columns, and in future, the business might need the calendar dimension attributes for each of the date columns.