Hi, You could use the TOPN function and apply it by "Service Type", because only 'Service' has more than 10, the other values of "Service Type" will always shows all the "Service Description". Something like RANK(Total by Service Type) < 11if you want it as explicit filter. You can also look at TOPN, which will do…

You could use another dataset that will contains all the parameters you need, and then you join it with your data in the dataflow and by using join conditions you can "filter" your data based on that variable value you have in the parameters dataset.

You need a proper "time dimension", a source of data with all the days, and then join it to your current data to generate the status of each record at any point in time. There isn't a thing doing time based trends out of a line with start-end or open-close, you need to transform your data into a row per each record and…

Hi, You should consider providing more information, more context, about your question. Keep in mind that what is probably obvious for you because you have been focusing on it for some time, is unknown to everybody else here in the forum. Starts by describing what product (and version) you were using (from where you did…

existing application roles from production What is "production" for you? A product name and version would help in understanding where your application roles are from. In OAC your application roles would be imported from another OAC via the BAR you will deploy. I assume your "production" is something else than an OAC…

It's fairly obvious, and expected, to have new features and changes in a product between versions. Also keep in mind OAS 5.9 is not supported anymore: it was released in 2021 and support ended in spring 2023. Sounds like you have another reason to upgrade: have a supported environment, and having access to the new features…

Hi, Your question is about a move to cloud of your EPM solutions, not Oracle Analytics. This forum is only about Oracle Analytics. You should ask in a forum about EPM/FDMEE products. I can't remember off the top of my head where they are, have a look in the following forums: edit: Looks like the best place for your…

@Mr.Bai , This forum is only for Oracle Analytics products. For general Oracle Cloud questions, you should go to and find the best matching category (or, as suggested above, handle it with Oracle Support).

You could set a filter based on an expression using the AGGREGATE( … AT …) function. Your FY column is hopefully part of a dimension of some kind (a time dimension probably). There you should have a grand total level, if you do write the expression AGGREGATE( "Amount" AT "name of the dimension level above FY")you will get…

Hi, What product are you asking about? Your question being about data, it sounds like it is about some kind of pre-packaged data of some kind, and not really a Publisher (technical) question. Based on the product you are using, the question could be moved to the right category, or you can be pointed to the forum looking…

Ok, thanks for the screenshot. So you have a pivot with COLUMN1, COLUMN2 in the rows, FY in columns and Amount is your measure. Now you want to filter the rows of your pivot based on the total of Amount (all the FY summed together by COLUMN1 and COLUMN2). And you said this is a "classic" analysis built on a dataset and not…

@Cindy Owings-Hutchison , while probably not what you look for as you expect (rightfully) the tool to cover the need, the json format of the semantic model is simple enough to easily generate any kind of documentation you need with a simple script. The older MDS XML format had tons of IDs and UIDs and also some FQDN…

Steve said it all… At this point in time, hierarchies as seen in the videos should come from the semantic model. In your case you are using a dataset, and there you don't really have a full model. It can be seen as a basic, simplistic, implicit model mostly. In the roadmap there are hierarchies for dataset planned for the…

It's quite challenging to imagine what you are working with and understanding what you are trying to achieve. What product and version are you using? What piece of the tool are you working with? ("classic" analysis, DV workbook, Publisher report) What is your data source? Semantic model or a dataset? You apparently…

It's possible that the complex join is returning more data than the join you had previously. There shouldn't be a different in data quantity limits based on the kind of join. Actually the tool doesn't care about the kind of join, it is just used to generate a query. The data limits jumps in based on the number of…

@muneezaniaz , if your employer bought OAS, they should have a valid CSI for it. Ask them to link your profile to their CSI so you can submit a SR. If you don't have a license for OAS, it means you are just having a look around the product (without a license). In that case you could consider installing it in Linux and see…

Needing 2 datasets is what I believe is your only solution as of now, because you need to have the managers and the employees as "separate" lists to be able to check for existence of one in the other list. Also, because it isn't about counting things, there aren't really simple workarounds by trying to "aggregate" at a…

When you did the process (the official one posted by Steve), did it take a long time? Did it return you a success message? Did you do it from an administrative account? If you want the "not officially supported" way (sorry to stress this point, but you should know what you get yourself into), the process can be seen as…

In OAS SSO is managed fully outside OAS, by your OHS (or any other proxy you have in front). Therefore you can look at how to set that header in your OHS config, you should have a place where you handle the SSO piece and then proxy to OAS.

I did click on that restore option not long ago during a 12c to OAS migration. While it didn't work for a number of reasons (corrupted catalog etc.), a number of the 600 agents in the catalog have been successfully enabled, including those that were in private folders. There are other ways to do the job, but aren't…