Hi @kusuma l -Oracle , The error message that you are getting is usually associated with a suboptimal report (and/or data model) design. Could you please a screenshot of how you created the visualization which is causing the issue? In OAC, the limit on the maximum number of rows is strictly related to the OCPUs number of…

Hi @Jean-Pierre Hoedenaeken , I repeated the test on a newly create OAC instance with the November update, and again the filter is working as expected. I noticed that you are using the ODBC 3.5 connection type to access your physical data sources. I highly recommend you to select a native driver instead if possible (e.g.…

Hi @Jean-Pierre Hoedenaeken , Which version of OAC or OAS are you currently using? I tried to replicate the same on my OAC instance (September 2023 Update), and the filters are applied as expected. It smells like a bug to me

Hi @Jean-Pierre Hoedenaeken , I believe that nobody is willing to open a docx file shared on a forum. I suggest to share a PDF file instead, or screenshots

Hi @Debadrita Ghosh-Oracle , You could make the bucket public, which means that there will be anonymous, unauthenticated access to its content (it's sufficient to have the link). If your files are already in a shared file system and you can access it through a public IP, then you don't have to setup anything special in…

Hi @Debadrita Ghosh-Oracle , In OAC: Files uploaded directly to the catalog can only be downloaded using a link You can't deploy a shared folder on Weblogic and expose it as a path you defined (e.g. res/s_Alta) As a workaround, you could upload your files to a bucket in OCI Object Storage, or any other location that you…

Hi @User_USWXB , This is a 4 years old thread. I suggest you to create a new thread in order to describe your issue, provide all required details, and properly manage the answers that you will get.

Hi @Jean-Pierre Hoedenaeken , The Relative Time filter does NOT generate new queries, but adds where clause conditions to the logical/physical queries generated from each visualization. Where did you grab that SQL code? By looking at it, I suppose that you are using a dataset with multiple tables from a database…

Hi @Jean-Pierre Hoedenaeken , The Relative Time filter does NOT create new queries, but it adds where clause conditions to the logical/physical queries generated from each visualization. Where did you grab that physical SQL query? By looking at it, I suppose that you are using a dataset with multiple tables from a database…

Hi @User_9SMBJ , What do you mean exactly by wrong sum? I can't see any SUM in the expression you previously shared.. Are you referring to the Sum in the Aggregation Rule (Total Rows) field? If so, what are you getting and what is your expected output (a screenshot would help)?

Hi @User_9SMBJ , It may sound stupid, but it's worth checking.. Did you format the column to display decimal places? You can do it in the Criteria by selecting Column Properties first, and then Data Format. Since integer was the data type of your column, there is a chance that 0 has been selected for decimal places. Of…

Hi @User_9SMBJ , I would replace 100 and 22 in your expression with 100.0 and 22.0. In this way you will execute a division between double values instead of integers (which can cause issues). As an alternative, you could multiply both the numerator and the denominator by 1.0 .

Hi @JMLMIII , Sorry, my bad! The ATTRIBUTE function requires to provide numerical values as input, but you have date values instead. As a workaround, you can convert your date values to numbers first, and then apply the ATTRIBUTE function: ATTRIBUTE(YEAR(MAX(Completion_Date by Person_ID))*10000 + MONTH(MAX(Completion_Date…

Hi @Kristian B. Joergensen , Can you share more details about the dashboard prompt? e.g. the data type of the prompt, whether it's column based or a variable one, the way you are populating the list of available and default values, the way you are referencing it in any analyses in the dashboard, etc.

Hi @User_DCJG6 , Your script is a customization that you (or someone else) wrote for OBIEE 12c. It has NOT been provided by Oracle as part of the tool, and certified to work in OAS. As I already wrote, several things are different in OAS compared to OBIEE 12c. I would check whether the functions and classes referenced in…

Hi @JMLMIII , You can't suppress values for measure columns. Only values for attribute columns can be suppressed when repeated. You could try by transforming your column into an attribute using the ATTRIBUTE function: ATTRIBUTE(MAX(Completion_Date by Person_ID) BY attribute_list) Please note that the BY clause and the…

Hi @User_DCJG6 , Even if OAS looks mostly the same as OBIEE 12c (at least for Classic Analytics and Publisher), a lot of changes happened under the hood, and these can impact existing customizations. There is no magic button that will make your customization works again, and we can't help without knowing how the…

Hi @User_ANT46 , It may sound a stupid advice, but did you restart OAS (or at least the obis1 process)?

Hi @Jean-Pierre Hoedenaeken , It's not possible to produce the Repository Documentation directly from the Semantic Modeler. You have to export it as RPD file and use the Admin tool.

Hi @Manu R-Oracle , I'll be happy to help, but I can't access that instance with my account