Blog

All categories and ta

Read more

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

Read more

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

Read more

Read more

Read more

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

Read more

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 …;

Read more

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)

Read more