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…

Please do not double post

Please do not double post

Hi, Do you mind sharing the product name (and version) you are using? There are chances you are in the wrong forum, but can't really point you to a different place without more details of the product you are currently using.

Hi @Miguel Cardoso , The expression you posted, and the one Federico provided, will be evaluated only at the row level. It will return "Y" only if a person is self-managed. Are you trying to look if "Person Number" exists anywhere as a "Manager Person Number" in your whole dataset to identify by Y the persons being…

If when you analyze your data you do use only one or two of the 3 "OR" conditions in that join expression, what you can do is to create new aliases for that physical table and join them to the other table with the 3 different join expression (that would become just foreign key joins with columnA = columnB and … ). Then…

Just a random thought : is that a valid config for obis.properties? You are on Windows, and the export VARIABLE_NAME is a Linux command. You could maybe try with setbut no idea if it is "that simple"…

Is the page doing the embedding behind something? F5, proxy or anything else? Because if yes, the domain you add in OAS could maybe be that one, not the F5 or proxy etc. Or maybe all of them, as in theory the embedding is done by the browser that sees those sites at their “public” address (not fully sure with such a…