We are glad to announce the updated version of dbForge Query Builder for MySQL. The tool offers users a great solution to build, generate, and handle MySQL queries from simple to complex in a visual and easy-to-use interface. In this version, the team focused on the Data Reporting and Analysis feature that allows for fast […]
The post Meet New Possibilities to Data Analysis with a New Version of Query Builder for MySQL appeared first on Devart Blog.
A couple of months ago I wrote about how you can use the MDX
functions Ancestors() and Ascendants to retrieve the full lineage of
members. (See: "MDX: retrieving the entire hierarchy path with
Ancestors()".)
As you might recall, the immediate reason to write about those
functions was to find a pure MDX solution to implement the "Show
Parents" / "Hide Parents" functionality offered by OLAP cube
browsers. To recap, developers of MDX-based pivot tables face a
challenge when rendering the result of a query like this:
[Read more]
SELECT CrossJoin(
[Product].[Product].Members,
…