Author: nasar

OSSIE Main site https://ossie.apache.org/ OSSIE Slack https://app.slack.com/client/T09QZ847AHK/C0ADR49SBEK GitHub https://github.com/apache/ossie Purposed Semantic Priorities by Will Pugh (Snowflake) https://docs.google.com/document/d/1EgG5vOlJSubm01S1AGMJ4MKcMcjxBhJHenGKWMr849E/edit?tab=t.0#heading=h.j6w0xp85sxzv OSSIE BI – Semantic Layer Interface https://docs.google.com/document/d/1uKc3x9NlvV9O9UPdvlnCTDxsc-XWsQrxb0ylG45H-IQ/edit?tab=t.0#heading=h.5vtm2vjqu4mp Proposed OSI Semantics – Foundation(Snowflake Working Group) https://docs.google.com/document/d/1bEuIb2eUpwesi6cIZ5FOkXMQDh7KAPIjZsWchmLgOAk/edit?tab=t.0#heading=h.l6gdpiq197e Apache OSSIE – Core Metadata Spec and Expression Language https://github.com/apache/ossie/blob/main/core-spec/spec.md OSI Proposal – Expression Language(Snowflake Working Group) PARTICIPANTSLLyod Tabb, MalloyDianne Wood, AtscaleLior Ebel,…

XSL, or Extensible Stylesheet Language, is a language used for expressing style sheets. It is primarily used for transforming and rendering XML documents. You can think of XSL as a way to define how the information in your XML files should be displayed, whether it be in HTML, text, or other formats. How does XSL…

https://www.freeformatter.com/xpath-tester.html From BIP data model, goto CODE tab and select the xml string and paste it above website (option 1) In XPath expression type the following: /output/nodeList/dataStructure/group/element/@name Make sure to uncheck ‘Include XML Item Type in output’ To get XPath, start from bottom (or last lines) of XML Another website to get XPath from XML…

1 – Python API Tutorial: Python API Tutorial: Mastering Data Retrieval and Integrationhttps://www.youtube.com/watch?v=qJPw_IVEyfc 2 – Python Pretty Print JSON String: Enhance Readability with Proper Formatting of JSONhttps://www.youtube.com/watch?v=tl5sYlVxBwY 3 – Python JSON Parsing: A Step-by-Step Guide to Extract Data from JSONhttps://www.youtube.com/watch?v=nKtyWfqNmr8 API – JSON – PYTHON: https://www.youtube.com/watch?v=YgO5ff9sp7A https://www.youtube.com/results?search_query=python+dataframe

In OAC dv visualization, there is no option to hide NULL rows,  like we have in oac classic analysis. Here is the workaround, to suppress NULL rows in a   oac dv visualization. ——— Lets say in a visualization, we are looking at two columns – one is measure called ACTUAL and another one is a…

Bind variable in DDL is not allowed You cannot user a bind variable in DDL statements and ALTER is considered a DDL statement. You would need to use dynamic sql for this exec sql execute immediate …. some string …;

Databricks Community   –  Forum style community where you’re able to browse and create posts which our engineers pop in and answer questions, regularly Databricks Documentation – Built to provide how-to guidance and reference information for all users. Hands-On Workshops – Expert Solution Architects lead interactive sessions, highlighting various facets of the platform. On-demand recordings will be sent…

OAC documenation: https://docs.oracle.com/en/middleware/bi/analytics-server/datamodel-oas/create-and-manage-level-based-hierarchies.html Oracle OAC blog: https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-for-dimensional-hierarchies-level-keys-and-content-levels OAC best practices: https://blogs.oracle.com/analytics/post/oracle-analytics-best-practices-series-optimal-performance-and-usage

https://docs.oracle.com/en/database/oracle/oracle-database/19/inmem/populating-objects-in-memory.html In-Memory activation at CDB level alter system set heat_map=ON scope=spfile;alter system set db_keep_cache_size=400M scope=spfile;alter system set inmemory_size=400M scope=spfile;alter system set inmemory_max_populate_servers=4 scope=spfile;alter system set inmemory_virtual_columns=enable scope=spfile;alter system set “_inmemory_64k_percent”=5 scope=spfile;alter system set “_inmemory_small_segment_threshold”=0 scope=spfile;alter system set “_optimizer_use_feedback”=FALSE scope=spfile;alter system set “_imado_enable_coloptim”=FALSE scope=spfile; This will give 400MB to the keep pool cache and 400MB to…

Select t.owner,t.table_name,to_char(nvl(sum(s.bytes),0) / 1024 / 1024 , ‘9999999.99’) mbfrom dba_tables t,dba_segments swhere –t.table_name not like ‘DECOM_%’ escape ‘\’ — does not start with decom_— t.owner = :schemas.owner(+) = t.ownerand s.segment_name(+) = t.table_nameand nvl(s.bytes,0) > 10000000group by t.owner, t.table_nameorder by 2 desc; select nvl(tablespace_name,’ – Total – ‘) tablespace_name,round(sum(bytes)/1024/1024/1024,1) as size_in_GBfrom dba_segmentswhere tablespace_name not in (‘SYSAUX’,’SYSTEM’)group…

YouTube videos by Oracle https://www.youtube.com/@OracleAPEX Blogs https://blogs.oracle.com/apex/ https://videohub.oracle.com/esearch/search?keyword=apex   (some non-English content also) APEX documentation https://docs.oracle.com/en/database/oracle/apex/index.html  APEX discussion forum  https://forums.oracle.com/ords/apexds/domain/dev-community/category/apex APEX community https://apex.oracle.com/pls/apex/f?p=411:18