on 06-11-2012 11:21 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.