Y
Yvette Teiken
Dear NG,
I use ADOMD to programmatically access MS Analysis Service. In
collaboration with the MS SQL Server works well. I wish to use in my
project next to the MS Analysis also Pentaho Analysis Services. Since
both do XMLA support it shouldn't be a problem. Problems occur, however,
when I try to query ADOMD Pentaho to get more than three dimensions. I
have inspected the XMLA, which exchanged and found that the ADOMD client
requestes another (axis) format , if more than 2 dimensions are
requested and Pentaho can unfortunately not answer in this required
format .
my question is now whether someone ever had this issue, and whether and
how it has solved. Maybe there is a possibility that the ADOMD his
client requests in a different format.Otherwise, is there any chance to
get Pentaho to understand the different format (axis) without a lot of
implementing? Maybe there is even an adapter somewhere. I would be
grateful for any tip.
Best Regards,
Yvette
I use ADOMD to programmatically access MS Analysis Service. In
collaboration with the MS SQL Server works well. I wish to use in my
project next to the MS Analysis also Pentaho Analysis Services. Since
both do XMLA support it shouldn't be a problem. Problems occur, however,
when I try to query ADOMD Pentaho to get more than three dimensions. I
have inspected the XMLA, which exchanged and found that the ADOMD client
requestes another (axis) format , if more than 2 dimensions are
requested and Pentaho can unfortunately not answer in this required
format .
my question is now whether someone ever had this issue, and whether and
how it has solved. Maybe there is a possibility that the ADOMD his
client requests in a different format.Otherwise, is there any chance to
get Pentaho to understand the different format (axis) without a lot of
implementing? Maybe there is even an adapter somewhere. I would be
grateful for any tip.
Best Regards,
Yvette