Thank you, so this entire directory structure thing is all about "disk space" and there are no real concerns about the product functionality !!! So keeping this disk space issue aside, am i good to proceed with the in-place to 12.2.1.4 with the current directory structure ? (and eventually another in-place from 12.2.1.4 to…

Thanks Gianni, is deleting 12.2.1.3 Oracle Home mandatory to make a successful working 12.2.1.4 instance ? (after in-place). --sorry if this question sounds too naive. As my current structure is /obi/Oracle/Middleware/Oracle_Home/user_projects/domains/bi, Now that if i choose to uninstall and re-do entire 12.2.1.3 buildup,…

Thanks Chris, below is how the existing directory structure of ours (for OBIEE 12.2.1.3) /obi/Oracle/Middleware/Oracle_Home/user_projects/domains/bi. I just ran the install wizard for 12.2.1.3. and the above is auto generated (only Oracle_Home i did specify in the 3rd step of process). Also you said "if you installed your…

Hi, Anyone any inputs on this please.. Thanks.

Thanks Chris, at most we just keep moving BAR files between these environs. Of course any config files like NQSconfig and instance config undergo any modifications, we are going to manually edit them in the other environment.

Hi .. Any inputs please .. Thanks

This is no longer an issue, specifying connection string in [database name]:port:[host name] resolved the issue, Note: this issue happens when RCU ran on MS SQL server databases only.

Thank you, just downloaded on that same link and the name of downloaded file says "fmw_12.2.1.4.0_infrastructure_Disk1_1of1.zip"

Having invested good amount of time in this install process, can't afford to lose more time, so trying to figure out the correct software from the list.. Thanks.

Thanks Gianni, but the download page is a bit confusing with lot of options (different softwares for 12.2.1.4), please point the right one, Thanks..

Hi.. Understood that usage tracking gives the user details, timestamps, logical and physical queries hitting the database. So is there a way we can get info on the "last viewed dates" of all reports in the catalog using usage tracking ? (if not possible in usage tracking, apart from parsing presentation server logs (sawlog…

Thanks Gianni, that's helpful.

Hi Chris, a) OBIPS logs -- you mean the "sawlog*" files , the oldest timestamp i see in those is 10/26/2021, so seems it doesnot help. b) Usage Tracking, checked NQSconfig file, under "usage tracking" section, i see ENABLE = NO. Please let if there's any third way.. Thanks Gianni --- yes you are correct, unless user…

Hi Gianni, Out of the 25, identified 8 reports which are very slow (others return data in seconds ALWAYS, these 8 reports sometimes take 5 mins, sometimes upto 25 mins), DBA identified creating indexes shall speed up those slower ones by 60 to 99%. But just want to figure out apart from having no indexes on the tables if…

Thanks Gianni, that's really helpful.

Thanks Chris.

Hi Gianni, no, when we wait till it loads fully, then no issues, happens only when tried while its "still loading". here i am trying to understand what's behind this dashboard's behaviour, some times fully loads in 5 mins, sometimes even after 25 mins, it still keeps loading (for the same prompt values). For ex: i ran this…

Hi Chris, * OBIEE 12.2.1.3.0 * google chrome, version 93.0.4577.82 (Official Build) (64-bit) * Mistake, all of those are analyses. * Log files -- i don't see any entry in sawlog0 file of OBIPS in that timeframe, but in bi_server1.log i see below error (posting here just the first line as there is a lot of java related…

Chris/Gianni, this dashboard is running against OLTP database (i am aware these BI/reporting tools are highly recommended to run against OLAP data warehouses). So wondering if there's a difference in tuning approach for OLTP vs OLAP sources in OBIEE... Thanks..

Hi Chris, this rpd got migrated from 11g (few years ago, not recently), to 12c, all these years able to check in changes, suddenly this issue araised, reason is while upgrading some files did not got updated as required, tweaking xml files fixed this. Thanks.