Welcome to the Oracle Analytics Community

Home› Marco Zerbini› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Marco Zerbini Rank 2 - Community Beginner

Comments

  • https://community.oracle.com/tech/apps-infra/discussion/comment/16823453#Comment_16823453 I found this in Oracle Doc: "Instead of specifying a named item for columns, you can specify $n or $-n. Here, n is an integer that indicates the item's row position. If you specify $n, then the measure is taken from the nth row. If…
    in Filter without affecting Grand Total Comment by Marco Zerbini Jan 27, 2022 9:44AM
  • https://community.oracle.com/tech/apps-infra/discussion/comment/16823373#Comment_16823373 Yes, but in the calculated items or group, is not exist the Override Prompt option...
    in Filter without affecting Grand Total Comment by Marco Zerbini Jan 27, 2022 8:43AM
  • Great! I resolved using the selection steps and Calculated items or group. But I don't remember functionality the "Override Prompt" option, so: 1- Create the Group Item contained all values (Total field) 2- Keep only values that I select on Prompt, using the "Override Prompt" option Now, I have only a issue, the values…
    in Filter without affecting Grand Total Comment by Marco Zerbini Jan 26, 2022 1:54PM
  • Thank you Gianni, but I can't create separate analysis because I have to use the hierarchy objects. The solution, I can use combine criteria, so in the first criteria I use the filter, in the second criteria I dont' use the filter (so I have the total).... But in this way, Hierarchy object and multi criteria is not…
    in Filter without affecting Grand Total Comment by Marco Zerbini Jan 21, 2022 11:17AM
  • Hi Christian, following I reply your questions: 1) Version OAS 5.5.0 with Oracle Analytics 12.2.1.4 2) I means Oracle Analytics (Answers) 3) I try to describe: I have in source this rows: ID - FIELD 1 - Dimension 19A - TEXT 1 - Valore1 05A - TEXT 1 - Valore2 In Analytics, I want result on Image1, so: Field 1 - Case when…
    in Issues Dynamic Dimension from measure Comment by Marco Zerbini Dec 6, 2021 4:32PM