Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
@User_OBCXC You may also check https://docs.oracle.com/en/middleware/bi/analytics-server/datamodel-oas/model-time-series-data.html#GUID-B7C1DB63-74C7-46A4-B4C1-A647453DA92B
-
@User_WQKHO so we will have two calculated items one as described in the above post to get the SUM NOT including the Filter and the other One which has the SUM without the Filter this workaround based on the screen shots uploaded
-
@User_LWG2Y I created a use case based on the Screen shots you attached 1- First created a Parameter to hold the Filter values 2- Create Dashboard Filter to select the Parameter values 3- Create your Calculated Item as follows Please Adjust the logic based on your Use case Let me know if this works for you
-
@Ivan M. This should be handled by Weblogic Server Team as users not showing up in WLS Console Page but search missing users in WLS Console to see if you are able to find them also I would suggest to use third party tools like Or are you able to see the users or still missing
-
@Conor Murnane if you are using filters make sure you disable filters when workbook loads because that will execute queries during the workbook load
-
@Karthick_ you may use expression Filter to exclude parameter value Ex:
-
@Conor Murnane you may check the following blog also check
-
@User_KURX7 if HTTP port enabled from WLS Console Page On port 9502 you may open new incognito browser window and paste http://hostname:9502
-
@User_Y6C7L For Hourly(last 24 hours only) chart . I have set - Last 24 hours - Relative to : Today , but It's displaying records as per other time zone (Possibly UTC) . My Time zone is GST (Gulf Standard Time). »I can reproduce the day issue with your excel file I think his is a Bug and need SR to be filed because after…
-
@User_VMJII Please check ☝️
-
@User_VMJII in your Database what is the TimeZone you can change same time Zone in OAC/OAS System Settings Or change "Default Time one for Date Calculations" to get correct value when extractDay function used "Default Time one for Date Calculations" can be found under system settings
-
@User_Y6C7L you can disable Auto-Apply For Filters please check
-
@ALOK SH-Oracle Using TOP N should be fine if you want to show top or bottom N Customers, sales and so on but from your report I think you are using a calculated items in your report if this assumption is correct I will suggest to use Rank Function that will show the Rank in front of each customer based on your report above
-
@Dhaval Parikh Stantec Are these Datasets under Users (My Folders) or Shared folders ? you may use DV Governance from let me know if this will show All Datasets then we can try to change the ownership for all
-
@User_SI7HK you can use physical query to build the report As SELECT department_id, last_name, salary, RANK() OVER (PARTITION BY department_id ORDER BY salary) RANK FROM employees WHERE department_id = 60 ORDER BY RANK, last_name; You can match the query to fulfill your requirements or you can use Gianni option for just…
-
@ashraf817 Do you have Only 1 User who creating your connections & Datasets or Multiple users also its good to check the logs
-
@User_OP60S Is that a VM Machine On top of M1 Processor Mac IOS ? Or regular Windows Client Machine in your laptop Or desktop ?
-
@User_SI7HK This is more SQL Question which need your DBA engagement please if you can give us a sample here to the tables rows we may be able to assist or route to correct community I am assuming DB is Oracle DB is that correct?
-
@Misan Omatsone If you using your SMTP Server please consult your SMTP Server for license issues in OAS we do not have any restrictions if there any restrictions will come from your SMTP Server I hope this is clear
-
@Karthik-Oracle no Need for OAM unless you strict with OAM Only in between you can create SAML Application in OCI IAM Domain and use docker solution as stated her SAML 2.0 and Kerberos Single Sign-On Configuration for Oracle Analytics Server (Doc ID 2761678.1) or use Configuring Oracle Analytics Server for SAML 2.0 Single…