I need to create a package for Self service BI. What should be the approach for it. I already have packages for normal reporting
Do you mean the use of Query Studio for Self Service BI as opposed to Report Studio for more complex reports? In other words what makes the difference compared to 'normal reporting' Please elaborate :o
Ya, we have a package which we use in report studio. This is used by the more technical developers. I would like to build one for query studio/analysis studio that could be used by power users or other business users
I guess what you mean is that the package should be made in a way that lets the business users make their own reports without having to understand the technical complexity which is what would make it a BI solution instead of a reporting solution ? That kind of a package is usually very intuitive so that the users do not have to take lot of trainings to use it and moreover it should not have redundancies and every object should work no matter which part of the package it is selected from (no cross joins etc)
I just finished a project on this. Redesigned the Business Layer. The earlier one was driving the users nuts and now they love it ! However I would still not consider that as an ideal BI solution because the DW has limitations so I could make it close to perfect but still not perfect.
I would love to know what others have done so far.
maybe add screen tips for query items