Hello,
I am using WEBI XI R2 and have the below set-up and the report requirements.
UNV1 :
Emp ID1
Emp Name1 (Format = FirstName LastName )
Forecast Mapping
Fiscal Qtr ( Format = MON-YY )
Weekend Date ( contains only Friday Date)
Actual$
UNV2 :
Emp ID2
Emp Name2 (Format = LastName, FirstName )
Team
Role
Fiscal Qtr ( Format = ‘FY’ || YYMM )
Week# ( Contains a Serial Number. Starts with 1 for each Qtr and incremented for each week )
Target$
I have merged the dimension Emp ID1 and Emp ID2 only … as Fiscal Qtr do not match in the format.
Also, created a DETAIL Object for each of the non-merged dimension object from both the DPs.
But, unable to display combination of objects from both the DPs together in a single block as:
Week# Emp ID1 Emp Name2 Team Role Target$ Actual$
Also, there is a cross-tab report requirement, for a Fiscal Qtr is as below :
Team/Week Week1 Week2 Week3 …
Team1 actual$ actual$ actual$
Team2 actual$ actual$ actual$
… …
Could anyone help me out in building this report ?
Any help is much appreciated.
Thanks,
Sarah
SaDSha (BOB member since 2008-09-30)