What is a report for you? A report is generally a Publisher report, then you can have "classic" analyses and DV workbooks. Catalog Manager CLI will be limited, mostly because it does enforce security when executed in online mode. The API posted by Joel has a chance to maybe bypass the security (because you just see a list…

@Minhajul Arefin , Steve has the right answer, you called the wrong script… startWeblogic.sh does just what the name says, it does start WebLogic and nothing else. OAS is not WebLogic, it is deployed on it but has many components that run outside WebLogic and that needs to be running for the WebLogic front-end to be…

I believe the "official" way Oracle imagined was to work at the BAR level. The issue is that a BAR is the whole environment, or whole pieces of it (all the catalog or not catalog at all, no granularity at all). If you are on OAS 2024 (7.6) you can use Semantic Modeler for the RPD part, that comes with native git support,…

As Steve said it isn't supported as a "click here to change hostname/ip/FQDN". If you read through various MOS documents you have the process to change a number of things. You are free to do a full search in the domain folder for any file containing the original hostname/ip/FQDN, to understand what they do in there, to…

Hi @madhavi Sunkara , welcome to the Oracle Analytics forum. When asking a question, you get better replies if you share a bit more than just a few words. It maybe does make sense for you because you are working on something, but nobody else can guess what you really mean. For example, "Oracle Cloud" could be any of the…

True, and that's why I started by repeating that the column selector was the official solution for that need… Anything else done by hand would have some downsides, like the empty columns still there. You can of course write a javascript thing to get rid of the empty columns etc., but is it worth it? At what point are you…

Just out of curiosity: what would you enter in a place where a hostname or URL is expected? Are you looking at not have any parameter with those values or you look for a kind of "placeholder" that will be replaced with a hostname at some point by some kind of process? (If your need is to clone an environment and then…

Hi, a dynamic table in which I can select dynamically the columns that are in it a column selector, but this solution isn't an option for the customer That was the feature designed in the product to handle the case… Use a prompt to select the columns, then saving the value in a presentation variable and having the logic in…

You could try with this kind of format: @{pv_select_value}['@'] I didn't test it, but it should give a list of quoted values of the variable, therefore it will work.

I must admit I never used it on dataset, because it's a "wrong implementation breaking the concept of data modelling" for me (time series should work on hierarchies, because that's how you can be sure of what query is being executed and what the meaning of that calculation is). My understanding is that you do not create it…

In the meantime, you should be able to do it without a time hierarchy:

Hi, There is a concept of datasets hierarchies, that I imagine will allow you to design what you ask. But it is a future feature listed in the 2024 Q3 roadmap (on the right of the page)

The issue is that errors in Oracle Analytics are fairly generic: a given error can have many possible causes. Having a maximum connections of 110 could still be too small, it all depends on how your environment is used. The idea behind that error, and what the MOS document doesn't say but hint to, is that you should…

@Jean-Pierre Hoedenaeken , Just to make it clear and be precise with words (because it could be confusing from the above reply). Oracle isn't providing a graphical UI for Catalog Manager anymore in recent version of the client, they give you command line version only. But the Catalog Manager didn't really change over the…

What product name and version are you using? Have you seen this? Oracle Analytics Analyses Fail Intermittently With [nQSError: 46006] Operation cancelled (Doc ID 2962591.1)

Hi, Yes, should still work without problems. The URL is the url of your OAC instance, instead of /analytics in the URL you need to use /analytics-ws and online mode only.

The DVA (the pre-built workbook) isn't in the ZIP anymore. But with the plugin you have the datasets with the source data, allowing you to build your own workbook using it. (Can't remember why the workbook was removed, Philippe posted it a while ago somewhere else, and he will probably soon be back here to post a comment.)

Hi, Because you talk about an analysis, I assume you are using "classic" and your source is the RPD (semantic model). You could create your concatenated column in there and then assign the "Descriptor ID" to that column being your code. The Description ID on a logical column is meant to handle the case when you have a…

Hi, The numbers do sum up to 100%, it's the format not showing decimals that make you believe they don't, as you said yourself. You could display 1 decimal, but still it will not solve the issue because you would still have rounding happening in the not visible digits of your values. There isn't a checkbox or a setting to…

That's no luck… Then it sounds like there is a mismatch between the database and the disk. If you look in the BIPLATFORM schema, in the SEMANTIC_MODEL_WORKSPACE table, you will find your ghost semantic model. But if the files do not exist on disk, it will never be able to open it. As for the reason of how you ended up in…