I am trying to figure out a good way to some SQL Server data available in BW as an InfoCube.
If I have a MS SQL Server Analysis Services MOLAP cube, can this be made available as a BW InfoCube? I know that BW can use MS AS as a storage mechanism for aggregates, but I have not seen if it is possible to make an existing MOLAP cube available from BW.
I guess the other strategy would be to assess SQL Server via DB Connect and build an InfoCube using the warehouse management BAPIs. This sounds pretty hard to me.
We are building a standard solution so manually creating the InfoCube in not an option we need to do it via vb.net or similar.
Any advice is appreciated. Thanks!