Welcome to the Oracle Analytics Community

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

Susan Z. Rank 2 - Community Beginner

Comments

  • That worked. Thanks so much for your help!!
    in Dynamic topN Comment by Susan Z. Dec 12, 2016 10:38AM
  • I did these: 1) Created a presentation PV_DYNAMICSELECT and selected radio buttons values to be : AMOUNT and VOLUME 2) I created a column in the criteria tab with the formula: CASE WHEN @{PV_DYNAMICSELECT}{} = 'AMOUNT' THEN "Purchase Orders"."Total Amount" WHEN @{PV_DYNAMICSELECT}{} = 'VOLUME' THEN COUNT(DISTINCT "By…
    in Dynamic topN Comment by Susan Z. Dec 12, 2016 9:46AM
  • I get some sort of syntax error Formula syntax is invalid. [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <=>: Syntax error [nQSError: 26012] . Please have your System Administrator look at the log for more details on this error. (HY000) Please have your…
    in Dynamic topN Comment by Susan Z. Dec 12, 2016 9:43AM
  • Thank you both Joel and Uma. I get the idea of the case statement When I try to incorporate that into the column formula in my Analysis though I get an error. That is where I am supposed to insert the formula. Right? In the column formula of the Analysis which is included in the Dashboard?
    in Dynamic topN Comment by Susan Z. Dec 9, 2016 1:26PM