Getting around the BEx Query Limitations using Analysis Office with Lumira
As you may/may not know you can only access the Visualize room with Lumira – no prepare, compose or share rooms are available.
But let’s say you have data in a BEx Query and you would like to share the Lumira story. First I access the BEx Query using Analysis Office and have 2 workbooks, one for 2013 and one for 2014. The data source to Analysis Office is a Solution Manager Incident Management BEx Query.
Figure 1 is a subset of the Analysis Office Workbook
Figure 2 shows the options merge and append. I appended the two Analysis workbooks
Figure 3 shows I used the “light bulb” related visualizations to get started reviewing the data in the Visualize room
Now I can create a storyboard, something I can’t do when using Lumira directly against a BEx query. I can also share it with Lumira Cloud.
The downside is the connection is not “online” but more of an off-line connection