Hi, I guess you can just ignore OWB (Oracle Warehouse Builder) and stay on ODI for all the ELT things (building a cube is a loading operation in the end). As Robert said, for cubes (real cubes) you have Essbase which is one of the references for ages now. Do not really always try to find a perfect match between a Microsoft…

Hi, Have a look at: runcat.sh -cmd archive and runcat.sh -cmd unarchive (or runcat.cmd if on Windows). You can script the archive command and specify the exact path of the catalog you want to archive (or a list of folders and reports).

user1137177 wrote:Just a quick check: can I directly go to 12C or I have to first upgrade to 10.3.6 and then to 12.1/12.2? Where does "12c" come from? 10.3.6 is just weblogic, and OBIEE 11g isn't certified on weblogic 12, so you better do not mix these pieces. If you are thinking / talking about moving to OBIEE 12c you can…

You are right but it's also the only thing I remember sounding like what you see, with columns just "empty". Also the patch has a name and replace a .so file which could also work for DDR. You can of course open a SR and follow the process there asking them if the fix cover your needs too or not. But if you have a sandbox…

Yes, that's the post I had in mind As you have the same version you maybe want to have a look into the linked bug/patch. The bugs not being public if you want to see more you will need to open a SR. The patch is available publicly in MOS, so you maybe want to give it a try ...

Hi, Did you try building a new analysis from scratch with the same query? Also maybe worth searching the forum here as I remember something similar (actually the same) some time ago. PS: it always help if you clearly identify the versions you talk about (full version number + bundle patch)

The "one shot thing" is the duplication: you aren't going to duplicate your model every week, you duplicate it once and it's done. So spending 1h to do the job isn't too much or impossible.

Database properties are ... easy to miss : too many and not the simplest to manage ... So you can maybe close the thread if you solved, by marking if required, for others having the same/similar question? Right now it's stilll This question is Not Answered.

I guess that's your thing. By default both 11g and 12c database types will set the "IDENTIFIER_QUOTE_CHAR" to empty (the default value), but I had a RPD around where in 11g it was set to double quote. The name sounds interesting and can be the one you look for. Check the value of this one in your old working RPD and then…

Hi Mark, Do you still have a copy of the RPD with the old "11g" database before you changed it? I would say you maybe changed some database features (properties of the DB object in the RPD, the "features" tab) to make the 11g work fine, and when you changed to 12c you got the default 12c database features. When you then…

Out of curiosity : why are you trying to include an analysis there? Where does the info come from in the analysis? Do you store the "down time" in a DB and change it daily? Do you update the analysis by hand ?

+1'000 to what Christian said There are some basic concepts in OBIEE security and in your post everything is mixed. Also the concept of "extraction" would deserve some extra details : do you want a simple web page listing them on screen (the link you posted) or do you actually want a real extract (generating a file…

You didn't really look at the posted link, right? 3. Give information about your environment, such as versions of software you use. This is essential, as versions change and other users might run into a similar problem never knowing if the thread they read was about their version. Because yes ... there are around 10+…

And the question is? There is generally a question mark somewhere Also have a look at on some extra info you can provide which are going to help you getting a better answer.

So you got a link connecting you to an online available SampleApp (not just a OAC instance). Then it's like said before: a RPD or a session variable can only be created in the RPD. In the front-end only presentation variables can be created. You can try to connect with Admintool to the host they give you, but if they…

Ok, I'm struggling to get the link between things ... So the SR was to have a link where you could download SampleApp v607 (OBIEE Samples ) locally? And you now want to reproduce your issue there? (so inside the VM you are running containing SampleApp) You can't create a repository variable from the front-end, just because…

Hi Rebecca, Somebody is mixing things here (you or your customer or both). OBIEE 11g and 12c can't be deployed on the same weblogic, so it's impossible to have a conflict there. You talk about a proxy, so I guess your custom setup a proxy in front of weblogic to access OBIEE, but in that case you do not want rename…

Ok, we posted in the same time and you confirmed what I thought Did the support also gave you a way to connect to the RPD? You can always try the default port ... But wouldn't be surprising if they didn't understand you have an issue with a RPD variable which require RPD access to reproduce (because a presentation variable…

In addition to what Christian posted, who sent you that link? Is it maybe after you opened a SR and the support is asking you to reproduce it on the environment they sent you the link? In that case you maybe do not have access to the RPD at all but just the front-end, which would be a bit dumb if you have issues with a RPD…

Sorry but I would avoid setting "REQUIRED" there or the users from AD will never be able to login. It's actually more to make sure the AD provider isn't set as required ... A quick reminder of what the values in the "control flag" means: REQUIRED—The Authentication provider is always called, and the user must always pass…