Mercury BI - Create a Pivot from a stored procedure

In my way of doing things, you do all the work that you can in a stored procedure and then send the result to the reporting platform. 

Today we're creating a stored procedure and feeding it to a Pivot in Mercury BI

 

 

First, here's our proc

Next, do this in Mercury:

Pressing 'validate' will show you the params

This step is important. You need to correctly assign the stored procedure fields to 'column area', 'row area', data area' or 'filter area'. Rows go down the left site, columns go across the top, 'data' is the information in the middle, and the remainder go in the filter area. 

The next three screens we just go past

 

In the end, you'll see the report in the report list, click 'close'

Back on the main surface, double click on the report to run it, enter the parameters, and click 'run'

 

You'll see that the GP demo company has sporadic data. If you'd like me to show you how to show all 12 months, LMK, I'd be happy to show that.

 

 

 

 

 

 

 


RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences