Skip to Content
Author's profile photo Oliver Nuernberg

Sharing Reports for the Sunshine Act

I want to start with a statement: “I am not a developer”. I learned Pascal (on an early Apple Computer with 2 (sic !) 180k (?) floppies) way back in the early 80s, learned a little Fortrun (did I even write this correctly?) in University in 1990 and wrote about 10 lines of ABAP in 1998. That’s it. Oh, I know a little SQL and XML. …so much for my vast development skills!

I am working on specific topics in the pharma and life sciences space and one issue that emerged is the US Sunshine Act, intended to shed some light on the amounts of money that pharmaceutical and medical device companies spend with healthcare professionals on free meals, educational material, seminars and so on. The whole is intended to make the connection between a physician and the pharma company a bit more transparent for the consumers. Most companies have tackled this and have already published these data…typically in a flat list that (maybe) you can filter by physician name like this Payment Report.  The problem is mainly to accurately collect the data from all the different IT systems that companies typically have. To build a report on these data and to share them in a controlled fashion should be fairly easy… so I thought.

Now I am sitting here and was looking for a way to prototype a simple report based on a table with about 10 columns and a couple 100.000 entries. As a non-developer (see above) this normally meant to look for a developer who understands how to do this, get the money to pay them and all this in no time. …. of course! And then I found Lumira! And to say one thing…. creating the sample data in EXCEL was the hardest part. Once I had a simple spreadsheet with sample data, the loading and creation of charts and a dashboard was rather easy.

Just a couple of things you should look at:

  • The desktop application freezes every now and then. So save early and save often. Saving a visualization or a dashboard doesn’t save the entire file.
  • I used the fomulas in Lumira quite a lot. This way I can refresh the source data (in the first few columns) and the calculated values are recalculated. Nice! I can control the calcualtions while somebody can suipply the raw data. So don’t do calculations in the source, do them in Lumira.
  • I finally managed to get my data onto a map as well. As all data are US-based all physicians reside in a US town in some state. So I didn’t had a “Country” column in my data. However you have to, otherwise the geo-plotting doesn’t work… the appliation actually freezes. And unfortunately the visualization always starts with a world map and you have to zoom to see the US only. I didn’t find a way yet to fix and store the zoom.

So within one day after actually understanding what Lumira is actually doing, I registered myself, I downloaded the application, I loaded a medium size data set (35.000 lines), I figured out how to report on the data, added formulas and defined several visualizations incl. a map; I put the visualizations into a Board, combined several Boards into a Story and shared the visualizations. … and this is one result (the legend is in the visualization but doesn’t show up in the board …):



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Aaahhh~~ The good ol' days of huge computers and actually floppy floppies. 🙂

      I'd like to know more about your application freezing. The environment, and circumstances that it was freezing under. Perhaps a step-by-step introduction on how to recreate, if possible.

      The map thing I've dealt with in the past, and it's in the process of being worked on. I'm looking for the ticket or more info - if you'd like to track it.

      Otherwise if you have any suggestions, you know that you can always share them via the Idea Place!!! Things get implemented from there in new releases!

      I like your suggestion of doing the calculations within Lumira, to preserve that kind of information, and just update with the data!!!


      Hope there's more coming~~


      Author's profile photo Oliver Nuernberg
      Oliver Nuernberg
      Blog Post Author

      Hi Bijan,

      sure. I'll add suggestions to the Idea Place. Reg. the freezing: I believe that happened when I added a filter to the raw data while the same filter was already set in a visualization. But I will continue to work with Lumira and will just drop a note to the Lumira Support when I encounter this problem again with more details. Main purpose of the comment was to make people aware that saving a visualization doesn't save the entire when the app froze all my stuff was gone because I never saved the file but only the visualizations.


      Author's profile photo Henry Banks
      Henry Banks

      Maybe hold off contacting ticket support until you've tried SP14 . i'm confident you won't see this problem again

      Author's profile photo Raul Saet
      Raul Saet

      Did you resolve the issue of the legends not showing up on the boards?

      Author's profile photo Antoine CHABERT
      Antoine CHABERT


      This is currently by design that legends do not show up in stories in desktop. SP14 will improve the situation though. Stay tuned.

      Best regards