Nov 04
Guest Post Author – Saurabh Gupta In this post we will go through recursive query with one example. The recursive query features enables to query hierarchical data such as an organisation chart or bill of materials ( check the raw materials used to make a product ). Using Recursive query data with in the single table can be …
Oct 10
Guest Post Author – Saurabh Gupta In this post we will go through ROLLUP function which is one of the Extended grouping function. ROLLUP is used to aggregate data along all the levels of hierarchy within a single dimension. For example – In time dimension data can be aggregated along different levels like day, week, month and …
