anybody found solution to that? I'm facing similar situation (will not have access unless I run function), and no idea how to do so. Maybe I shall have used initialization block instead? thanks

Ok, with @Gianni Ceresa 's last comment I was able to identify users with this page set as startingPage (did offline / fileSystem search, had some problems running catalogManager at linuxServer ) and take necessary actions. Thanks guys for helping, much appreciated.

@Christian Berg - actually, my problem is just starting page, not an object having been utilized somewhere and then removed. At this dashboard page that we are about to decommission, we put a 'banner' about its removal couple months ago. So if someone still wants to access that page - you've been warned, sorry. Also, we…

@Christian Berg I don't understand - is there any object in catalog that contains user's startingPage? I'm familiar with catalogManager's search option, but still don't know how can I find user's starting page? I'd appreciate if you could explain this. btw I forgot to comment at one sentence of @Gianni Ceresa first post in…

Thanks @Gianni Ceresa for answering this. Well, you aren't supposed to point to a missing page. It's just the equivalent of a HTTP-404. of course, but we have hundreds of users and I have no idea which one of them have this particular dashboard set as homePage And you can also consider running a scheduled job checking if a…

in case anybody is interested if solution was found to this: no, it was not, it had to be solved in ETL eventually

...so, here it is: and here goes the link to the googlesheet itself: https://docs.google.com/spreadsheets/d/1PQQjR5Zy4bqa6U0OVRXnndyhGQijWVsZnVmYw35zOSs/edit?usp=sharing is there a way to make the periodRolling actually stop rolling at the moment of time when metrics don't have values anymore? my month filter will equal to…

@Gianni Ceresa, thanks a lot. I forgot about this old trick with playing with join condition, been ages since I've used it last time. Eventually, I almost made it work, not 100% though, let me sketch the dataset again & I will explain where I do have an issue:

@Mark.Thompson : that's interesting theory, let me think about it a bit more during the weekend, maybe over a beer or two : ) I will explain you the business case then too.

11G patches: >opatch lspatches 18996188; 20022695; 19825503; 19823874; 19822893; 19822857; 19822826; 16997936; 16913445; 17220944; 16569379; *************************************************************************** *****12C below***********************…

11G is: 11.1.1.7.150120 (Build 150113.1200 64-bit) 12C is: 12.2.1.4.0 (Build BIPS-20190627163935 64-bit) Oracle DB to which both OBIs above are connected (it's one & same database) is: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production will post detailed patch information tomorrow cheers

# # #-------11G LOG: # # # [2019-11-21T23:30:17.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-0] [] [ecid: 42374480502d170a:-1281b15f:16e8e202b6d:-8000-000000000001c948,0:1:1:3] [tid: 4b4] [requestid: 3e870016] [sessionid: 3e870000] [username: KanickiK] ############################################## [[…

# # # #-------12C LOG: # # # # [2019-11-21T23:34:05.517+00:00] [OBIS] [TRACE:2] [] [] [ecid: b27afc39-238d-4a45-8f5f-785e3528d30b-00017c7b,0:2:17:3] [sik: ssi] [tid: 76dfe700] [messageid: USER-0] [requestid: d7410027] [sessionid: d7410000] [username: kanickik] ############################################## [[…

I was investigating a bit more..... seems the reason is not necessarily like it was in previous issue with aggregation being done in physical SQL vs. in BI server. Maybe sth else, no idea. Report itself is : the metrics that differs on 12C report vs. 11G report is the first metric '# of Sites Selected'. Now, if any of 3: *…

will share SQLs in the afternoon

Hi Christian, thanks for your help. The patch was just applied, it didn't help though.