If we have a requirement like we want a static table of data in OBIEE and we do not want to refer any data source, then we achieve this by creating View in RPD.
Oopen the New Physical Table window in RPD.
Give a name to the view, select "select" option from dropdown and write your query in the "defualt Initializing String" area.
Click on Column tab to add new column.
Note - The column name in the select query and the column name which you have added in column tab must be same.
Now join this table with Fact table.
In my case, I will create a alias table and make join.
Drag both the tables to BMM layer, and do the same join.Now drag the Static Table into presentation lay.
Restart the services and check the result in presentation services.
Oopen the New Physical Table window in RPD.
Give a name to the view, select "select" option from dropdown and write your query in the "defualt Initializing String" area.
Click on Column tab to add new column.
Note - The column name in the select query and the column name which you have added in column tab must be same.
Now join this table with Fact table.
In my case, I will create a alias table and make join.
Drag both the tables to BMM layer, and do the same join.Now drag the Static Table into presentation lay.
Restart the services and check the result in presentation services.
Good Post dude...helpful info
ReplyDeletevery Helpful
ReplyDelete