True that you can get everything via the webservice. But in the end: aren't you going to overengineering something? Not sure what exact product you have in front, Catalog Manager really isn't an option? You could do an archive of the catalog by command line / code and be 100% sure it will work in case of a restore. But…

Just to note that I wouldn't really consider this a backup. You get the content of an object, but the XML doesn't contain the ACL and other few metadata (like type of object, owner etc.). So it's really a pure "content" backup and will not be fun to restore. But better than nothing for sure !

Hi, So you want to backup the catalog, right? Sure you can do it by webservice, tested and perfectly working on OAC. You can look at this doc https://docs.oracle.com/middleware/1221/biee/BIEIT/methods.htm#BIEIT180 which describe the various services available. The one you look for is the WebCatalog Service. You find…

Just a detail : once deleted in OBI it's deleted forever, not into a trash or temporary place where you can get it back. So you either have a backup you restore or go with the ideas posted by Sricharan. (And the backup aren't done automatically, it would be up to you to setup a backup process and make sure you can restore…

Don't be jealous 

Not at all! Was more me complaining with myself because of doing things in the middle of the night a bit randomly instead of doing it in a more "qualitative" way in the morning :D Keep going with your OTBI (OBIEE), it's fun ... at least I believe it is. Always happy to support the community here in the forums like many…

Sorry for not having been more explicit (at 1:40AM on a phone was already not easy :D ) You set these formulas in the "Criteria" tab editing the formula of 2 columns (so add your "cost_center" twice and then change the formula in both to be the cost center ID and cost center name). You generally never edit the SQL (logical…

Hi Stefan, As they finally set permission on the forum it’s possible to reply... LEFT('00-00-000 HQ - CostCenter', LOCATE(' ', '00-00-000 HQ - CostCenter')) SUBSTRING('00-00-000 HQ - CostCenter' FROM LOCATE(' ', '00-00-000 HQ - CostCenter')+1) You can use these 2 formulas to get the left and right part of the column. As…

You can set it in DV > console > System Settings > Portal Path, just enter the path of the dashboard you want to use. And you can't change the behavior of the "Home" link in the top main menu in OAC : the homepage of the product is a different thing than the "starting page" you can set in "My Account" (or with the Portal…

I see what you are looking for and it's absolutely valid (and that's the default behavior of classic prompts in general for the same exact reason you said: to not change visualization, and the relative queries fired, till the filters are all set). Seeing a bit where DV comes from, I suspect it isn't an existing feature,…

edit: OP first reply was that my request for more info was pointless and not helping him at all. Now he did decide to provide more details and "look good" in the forum after this reply was posted (his reply at 21:16, my reply at 21:21 and him editing his reply at 21:32 CET). I will do as said and stay away from his thread.…

You say who is member of what group, what these groups are supposed to allow their members to do, what is the ideal behavior and then apparently complain about the current behavior. But what does your current security model looks like? Because yours is an extremely focused question on your own specific security model, but…

I would say these settings have no impact on DV. They are the settings for classic prompts that required to change the OBIPS config file (instanceconfig.xml), something that isn't possible in OAC and that's why they added these settings into the DV Console System Settings page (a way to change the things that can only be…

Of course you can't pass 'Jul-21' to your filter on "Accounting Period" if that was expected to a number 1-12. But if your time dimensions know how to handle the conversion, you can use a filter on "Month-Year" = 'Jul-21'. I would say that the problem is anyway not there: my report has 60 unions No idea what your analysis…

Yes, 2 LTS is what I had in mind as that's the only way in the RPD to get a union result. Otherwise you can of course build a view or a unified table in your database, but if have that option you probably wouldn't be asking :D

The physical tables can be 1, 2, 10 or how many you want. It's up to you to decide how to model them, to give them a role. Of course if you have data problems (missing way of connecting things) even modelling isn't going to help you. But otherwise it doesn't matter if it's the same table or not, as long as you have enough…

Model your table in the RPD as having 2 sources, one targeting the first column and one targeting the second column. The tool will do the job of doing the 2 queries and joining the results together.

First build solid foundations before to add extra floors on top? 100%! But I don't know why when I see DV I can't stop thinking at this...

Another proof that DV is not a replacement for "Classics" and it's time to stop forcing using DV just because it's the only piece being developed (trying to catch up with 15+ years of "Classics" doing the job perfectly).

when I select Jul-21 in drop down of dashboard prompt, then Period Number 6 should be returned to my analysis for further calculations in the criteria. That's a business rule you should cover in your model somehow. The tool is smart but doesn't do any magic. How is it supposed to know that July 2021 means period number 6?…