ad hoc webi reporting in BOXI 3.1?

[Former Member]

Hi

actually in one universe i have to use 2 independent tables along with the regular tables.

Tables:

1) current data table

2) historical data table

So user requirement is -

When user tries to query for current data then it should refer 1) current data table for the condition

When user tries to query for Historical data then it should refer 1) historical data table for the condition

and generate the report data for the user.

Even i am confused with this requirement. Never experienced.

Thanks,

Bhaskar

[former_member4998]

Hi Please try below steps.

@ Data Foundation

In the Data Foundation: join the tables like below.

Regular Table 1, Regular Table 2, Current Data table

Regular Table 1, Regular Table 2, Historical Data table

@ Business layer

Create Folder like Current and create dimensions and Measure etc, related to current data  objects under folder.

Create Folder like Historical and create dimensions and Measure etc,

related historical data objects under folder.

Create one Object like: Date Type with LOV’s Current Date, Historical Data.

@ WebI Report Level

Create WebI Report with two date providers.

Current : Select Object related to current data and in the query filer select object Date Type and enable as prompt.

Historical: Select Object related to Historical data and in the query filer select object Date Type and enable as prompt.

And then create report.

Table 1: Shows Current data ( Select Customer NO, City Name, Country From Current DP)

Table 2: Shows Historical data (Select Customer NO, City Name, Country From Historical DP)

Also create one variable to capture the user response from prompt.

V_Date Type=Userresponse(DateType)

Then alien both the tables in report and provide hide condition on tables .

Like

Table 1: Hide when V_Date Type <> Current Data

Table 1: Hide when V_Date Type <> Historical Data

[Former Member]

Hi Bhaskar,

Are current and historical data tables fact tables?

If yes, connect the regular tables with current fact table and create aliases of regular tables and join them with historical tables, a structure similar to above.

However, you will have to take care of the grain. The current data should be joined with time dimension (daily data) and historical data should be linked with monthly dimension or quarterly dimension as per the grain decided in historical data table as it must be containing rolled up data.

You might share the universe structure details and column details of current and historical data table as it might help in deciding the best approach.

Hope it will help.

Regards,

Yuvraj

[Former Member]

Yuvraj,

I will share more info .. on this

[former_member203850]

Is there any relation between above tables  ??

If No then

create two different class/objects for the above tables and use the same objects in adhoc report.

Correct me if my understanding is wrong.

Regards,

Pranay