Robert, tried multiple way, In first design we had Physical model almost same as above Logical model, there was no common join to bridge the gap. so changed the design,in physical model we have one dimension Dim_product joining to both the facts on different keys, In BMM we created 2 logical tables based on same physical…

thanks for the quick response Robin and Christian, same here, i never saw antivirus on Linux serves but the internal security at our organization installed antivirus on all the Linux serves including DB servers. i am running into issues every time i restart OBIEE after server reboots, now i am debating with security team…

Thanks for the reply Joel, points noted. will be working on it next week, will keep you guys posted how it goes. Ss

thanks for the reply Gianni, yes 12c Databases is on new servers so there will be hostname/IP etc changes.... do you or any others had this scenario? if yes could you please share the steps/ issues faced/ configuration changes needed etc... my main question Can we simply import the repository created by the RCU utility ?…

In Our case a total of 1000 users and less than 300 concurrent user may be. ya OBIEE doesn't store whole lot of data but user might run/schedule lot of customer facing documents from BI Publisher and tool will save lot of report job outputs, wouldn't this consume lot of space overtime?(we will delete and purge at one point…

so there is no place in BIP to handle maximum connections, runaway sessions and timeouts?