BO Dynamic Table IN Universe or webi

[Former Member]

Hi All,

we need solution to create dynamic table in Universe or Web Intelligence , as example below

Table : f_temp_Feb15_tbl

Feb15 should be dymanic or it should be given as prompt

f_temp_Jan15_tbl

we dont want to change table name , so instead do we able to change table name dynamically or by prompt

[former_member4998]

Hi

Could you please elaborate your requirements..I am not able to understand

[Former Member]

Hi Sreenivasulu,

Good Morning!!!

In our DB , every month we will create new table on month name and we need to use this tables as source for report.

Table names will be like

F_TEMP_JAN15_TBL

F_TEMP_FEB15_TBL

F_TEMP_MAR15_TBL

F_TEMP_APR15_TBL

SO ON

Every month new table will be created and we want prompt to give input to table name to get data for that month.

so when we refresh report ,we will give month as input and data for that month should be output in report

Regards

Mahesh

[former_member203850]

I don't think its possible  to change the table name dynamically (Monthly wise) in BO universe  .

It would be better if you create any View at the database end and use the same view in BO universe.

Here you just need to modify the view definition monthly wise at the database end  to accommodate your change.

Regards,

Pranay