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…

While the SR is the way to go (they will need a number of details that you can't share on a public forum), the semantic models are stored on disk, if they exist. Not saying that this is the way to do things, but it could help you in recovering or have a backup of your models that you could then import somewhere else, or…

For that case, what you could do, is to use a data flow doing the comparison between columns. Doing first a unique to Input 1 and then a unique to Input 2 or common rows and counting them and things like that. You can then save the result in a dataset and that will tell you how the 2 inputs are the same or not. You can…

also how do we access Fusion Data analytics, i a, totally unknown to this area Maybe you could begin by what exists in Fusion for analytics, and that would be better covered in the parallel forum Cloud Customer Connect that is focused on cloud apps, including Fusion HCM (lot of categories about that product, including one…

I don't have access to any Fusion product, and as far as I know OTBI is more like "classic" analytics, not DV. If that's the case (I don't know if current OTBI has DV or not), then it would be a different license. But with licensing, you should always consider speaking to the account manager. It's the person who should…

Hi, You mean by having a dashboard in which you display one source, the other source and various deltas between the 2? Or more about comparing if the full content of the dataset is the same as what the subject area returns without looking at the meaning of the data (more like a technical comparison than a functional one)?…

Hi, The question is quite vague, a bit like the other one about licensing. It all depends on what products exactly you are interested in: just OAC and doesn't matter much where the data is from and that's something you handle yourself? Fusion HCM Analytics? Something else?

Hi, What would be "their HCM solution" ? Do you mean they have Oracle Fusion Cloud HCM? Or did they buy Fusion HCM Analytics (one of the version of Fusion Data Intelligence)?

Hi, You are maybe in the wrong forum. This space is dedicated to Oracle Analytics products, and you seem to be having issues with some kind of integration. Is that some kind of integration task related to FDI or just one of the few available integration services in the cloud? Trying to figure out if this question should…