Author: nasar
-
Apache OSSIE – Previously called OSI
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,…
-
Qualify
Snowflake QUALIFY function In a SELECT statement, the QUALIFY clause filters the results of window functions. QUALIFY does with window functions what HAVING does with aggregate functions and GROUP BY clauses. In the execution order of a query, QUALIFY is therefore evaluated after window functions are computed. QUALIFY <predicate> The QUALIFY clause simplifies queries that…
-
XSL
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…
-
Extract data from XML
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…
-
Hide null rows and Sort rows/columns in oac dv workbook
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…
-
SQL tips
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 Links
https://databricks.com/learn/training/home (official training) ]https://databricks.com/try-databricks (Databricks Community Edition, free) https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks (Databricks on Azure) https://databricks.com/product/aws (Databricks on AWS) https://databricks.com/product/google-cloud (Databricks on Google Cloud)
-
sql MODEL BY clause
The MODEL clause enables you to create a multidimensional array by mapping the columns of a query into three groups: partitioning, dimension, and measure columns. These elements perform the following tasks: The MODEL clause enables you to specify rules to manipulate the measure values of the cells in the multi-dimensional array defined by partition and…
-
Manage Level based hierarchies in OAC rpd
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
-
Using In-Memory with Analytic Views
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…
-
Find Large tables in database
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…
-
Oracle APEX
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
Nasar's Blog 