@LukePa , what part of the product are you using? DV workbook? A "classic" analysis and dashboard? A Publisher report? The answer could change based on that… By "set a presentation variable name in the dashboard board", she means that because you can't filter the whole query by your "sales channel" (as that's the reason…

Hi, Welcome to the Oracle Analytics community an forum. Your question is related to the Fusion data, therefore you are in the wrong forum. Fusion products are covered by a parallel and independent forum: You may use Publisher in Fusion for reporting, but Publisher is just a technical tool, coming with no data. Data is…

The "issue" is that governed analytics and a DIY analytics (or self-service analytics) coexist on the same environment, overlap a lot, while not sharing much. This make it very challenging to define a process to identify content to move from the users' made analytics to the governed one. Mostly because it depends a lot if…

Hi Doug, Welcome to the Oracle Analytics community and forum. Yes, as you say DV is the Oracle answer to power users who want to do their own cooking without being limited to a centrally managed semantic layer (that's the semantic model in Oracle Analytics). In DV you have everything for a user to do a lot, sometimes too…

When restoring content from a snapshot, be careful! You don't have lot of granularity, it's usually a "all or none" for a kind of object (or many kind of objects all together). Therefore, restoring your deleted dataset, if it's a old-ish snapshot, you could lose a number of objects that have been created/modified in the…

Hi, Assuming your source is a subject area, you can either use a formula to keep the "total number of cars sold" at the grand total level of your sales channel dimension, or add a new measure in your logical table fixing the content level of that measure to always be on top of the sales channel dimension.

@Sentil , Did you check if an idea for that support already exists? And if not, you can create one:

If you are seeing the same login page for both :9501/console (or :9500 if no SSL by default) and :9503/analytics (or :9502 if not SSL by default), then you definitely have some errors, maybe on your proxy config. These 2 paths aren't managed by the same security solution and don't have the same login page. If you see the…

Hi, I'm not sure what direction this thread should take… If you are experiencing bugs with your OAC environment, then you can/should raise a SR (http://support.oracle.com/) and work on it with Oracle. A SR is a private space between you and Oracle, where you can share all the details, including private information, so that…

Hi, You look for the BI Apps warehouse schema table? (you posted in the OBIA category) Or you look for that info in your Fusion application? If this is the case, you should post your question in the forum covering Fusion HCM: It's a separate forum covering a number of cloud applications. If you look in the many categories…

Hi Marco, No, no need to repost it :) Just to confirm: is your question at least somehow linked to OTBI? Because maybe that's not correct… As far as google tells me, Simphony is the Oracle's Cloud POS solution. It isn't an Oracle Analytics product by itself, but I assume it does come embedded with some form of analytics…

@Prabhjeet Kaur , Fusion and related elements like PVO are covered in a separate, independent, forum: If you look at the list of categories there (top menu), you can see that there are many analytics and reporting categories related to Fusion. You can ask questions about Fusion PVOs in there as it's the forum covering that…

@Marco Gaspar Silva , no need to repost your question, it has been moved to the OTBI category.

@Hugo Forbes , No need to repost your question, it has been moved to the OTBI category.

@User_U8Q9Z , you are in the right forum. What @Gaurav Bharadwaj-Oracle meant is that it could be the wrong category. And if it's the case, with more details, your question will be moved to the right category. But you are in the right forum (there is only a single Oracle Analytics forum, all the rest is categories allowing…

Hi, Welcome to the Oracle Analytics community and forum. Just to be sure on the topic of your question: which part of Oracle Analytics are you thinking about? DV (data visualization) workbooks? "Classic" analyses and dashboards? Or Publisher? I'm asking because currently the question is in the Publisher category, but you…

Just being "picky" on @KDR solution: use a UNION ALL instead of UNION. UNION will enforce a distinct constraint on the overall result to remove any possible duplicate, which is maybe not what you want. And even if your records are already unique and nothing will be lost, it does take quite some time based on how heavy is…

Hi, Is it really not working? The error you have is not really an error, it is just telling you that your "query" wasn't expected to return any column, while now it does return 2 columns. If you run it in the Issue SQL page, you can see the 2 columns: Somehow it looks like your old agent was executing a query expecting no…

For anyone with a similar requirement, up-vote this idea:

Same comment as before: the feature is not there, it just doesn't exist like it doesn't exist on-premises. Therefore you need to request the feature to be added to the product via an idea. The challenge is to know where you should raise the idea: in the OAC category or in the FDI category? The feature doesn't exist in OAC,…