We are trying to decide on best strategy to access AS2000 and Essbase cubes. Would ADOMD.NET work for ESSBASE? If not, does anyone have .NET sample on parsing raw XMLA?
Mukesh Kumar wrote: > We are trying to decide on best strategy to access AS2000 and Essbase cubes. > Would ADOMD.NET work for ESSBASE? If not, does anyone have .NET sample on > parsing raw XMLA? At Simba, we have done a fair amount of testing and work with ADOMD.NET. From our work, we have found that ADOMD.NET does not currently work with Essbase. We have no idea as to when this will work. Having said that, maybe you can explain more of what you are trying to do so that we could give some suggestions. Best Wishes, Amyn
Thanks Amyn, We are trying to use OLAP sources(Essbase and Analysis Services) to populate some elements in our data warehouse. For ETL, we want to use a common method for all OLAP access. XMLA seems to be a good choice but writing a good XMLA parser from scratch is no fun.
mukvij@gmail.com wrote: > Thanks Amyn, > > We are trying to use OLAP sources(Essbase and Analysis Services) to > populate some elements in our data warehouse. For ETL, we want to use a > common method for all OLAP access. XMLA seems to be a good choice but > writing a good XMLA parser from scratch is no fun. Hi Mukesh, I am still not clear in what you are trying to do. It sounds like you want to pull data from both Essbase and AS into some data warehouse. I am not sure what the data warehouse is built using and also not sure what tools you are using. Normally, you would create an MDX query, wrap it in XMLA, and send it to either Essbase or AS. Essbase or AS would then send you back some result set wrapped in XMLA. Since this result set is in an XML format, any XML parser should be able to unwind it. The parser does not have to be specific to XMLA. You can email me at amynr at simba dot com and we can discuss further. Best Wishes, Amyn
