The new year has started and everybody is telling his wishes and hopes for the future.
I’m a BI consultant for a while now and I was thinking, what could really help me to make my job easier. I agree completely with Vitaly in his great blog What should be the Next Big Thing for SAP in BW/BI?, user friendliness is certainly one. But is this all?
I’m dreaming of a transaction where you can really “model” within BI. Shouldn’t be software so easy that you e.g. drag and drop the whole dataflow from your datasource to your cubes or multiprovider? I could imagine that you have at your right all necessary elements like in a painting software. Take the “color” or component you need and drag it on the right. Start with a cube for example. Then connect your Cube with a DTP or transformation. Finally take a datasource and connect it to the transformation. Don’t care about the fields in too much detail. It’s done by the software. I know that’s a top-down approach. But isn’t it the way you start data modelling? You write down the requirements from your client. From here you start to build your cubes. In the next step you look if there is any business content available you can use. You install it and find out, “No, that’s not what I want!”. Now you start again with building your own dataflow. Helpfull would a software that recognizes what you want to do and supports you in your work.
How can I imagine the future? You start again with the requirements written down in a document. Now you simply put this document in your BI system and say “create model”. Then the system reads through the document and creates the data modell. Cool, isn’t it? I admit the text has to be in sort of a “modeling” language. But that’s a future extension to BPEL! In the next step you add the source systems where your data comes from. Of course all master data is unified and no format errors occurs. You schedule the jobs for the next weeks and data is there where you want it to be. Sweet, sweet world…..
I dream of an “Administrator Workbench” where you can easily access and drill-through to each component you want. No windows with very small tables, three rows and 5 columns and you would need at least the double. No way to resize or to rearrange it to your needs. I dream of a workbench that you can configure how you like it. Get rid of all the windows, menues and buttons you don’t need. Add the ones that you really need. I hope that Web 2.0 brings lot of improvements here.
Errors in data loading, sad of the same error every morning? I dream of a system that can be trained to remove errors. Datasource in your R/3 have changed and now all your requests are red… One of the next versions does the replication before it tries to load data!
Ok, dreamed enough for the moment. Now I have to go back to my work and remove this silly replication error…..