Linked Univ / Different Date Ranges / Multiple Report Tabs

[BOLearner]

Hello all and thanks for any suggestions. I'm a newbie here and new to Bus Obj (about 6 months) so if anybody can tell me if this is possible I would appreciate it.

What I have in the simplest form is 2 universes of data linked by RecordNum
Universe A Universe B

Universe A Fields:
Date, RecordNum, 20+ more Data Fields

Universe B Fields:
Date, RecordNum 25+ more Data Fields

Example Data:

Univ A
Date RecordNum etc
1/1/2003 12345
2/1/2003 12345

Univ B
Date RecordNum etc
1/1/2003 12345
2/1/2003 12345


Here is my question:

Within 1 .rep file can I have on separate tabs:

Report1 Univ A Data (all fields)

Report2 Univ B Data (all fields)

Report3 Univ A match to Univ B by RecordNum
Univ A to have Dates for Month 1
Univ B to have Dates for Month 1 and 2
Fields to View
A.RecordNum, A.Date, B.Date, etc

Report4 Univ A match to Univ B by RecordNum
Univ A to have Dates for Month 1 and 2
Univ B to have Dates for Month 2
Fields to View
A.RecordNum, A.Date, B.Date, etc

Thanks for ANY and ALL assistance.
Jr

 

[blom0344]

Depends on what you want to match. If you want to link just on RecordNum I would fetch these as dimensions (and link them) , fetch the date fields as details and rest as measures/details (depending on their nature)

Be aware that BO automatically perform something like a FULL OUTER join between linked data-sets.

So if UNV A fetches Recordnum:

12345
54321

and UNV B fetches:

67890
09876

then resulting set is:

12345
54321
67890
09876

As far as the reports are concerned:

Even if you use linked DP's just using data from UNV A on a report tab will have BO act as if there just one DP getting the data, so there is no problem there.

You'll need some variables for reports 3 and 4, like:

= IF( MonthNumberOfYear(<date>) = 1 or MonthNumberOfYear(<date>) = 2) Then <date>



T. Blom
Information analyst
tbl@shimano-eu.com