Showing entries 1 to 2
Displaying posts with tag: pivot table (reset)
Meet New Possibilities to Data Analysis with a New Version of Query Builder for MySQL

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.

MDX: "Show Parents" - Redux: A generic and systematic MDX query transformation to obtain the lineage of each member

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:


SELECT CrossJoin(
[Product].[Product].Members,
[Read more]
Showing entries 1 to 2