"Sumudu Prasad" wrote:

> Can any body tel me how to generate RDL file (xml) dynamically for given MDX
> query.
>
> Iam using XML/A (XML for Analysis) for execute the mdx query and get the
> result set as xml file.
>
> Is there 3rd pary tool or Sample Code for this type of situvation.
>
> bcoz......... this report should be a Table control with drill down
> facility,.
>
> My main question is how to execute the MDX query and get the feild list, I
> know that I have to think of some logic to implement RDL (XML).
>
> but when I run this following query using xml /A , I am getting only a
> single feild. but it gives all relavent feilds when I run this on Sql server
> Report's 'Data' tab.
> here Iam tring to create drill down report for 'Product' dimension
> SELECT {[Measures].Members} ON COLUMNS,
>
> { Descendants( [Product].[All Products], [Product].[Product Name], LEAVES)}
> ON ROWS
>
> FROM SALES
>
>
>
> do Help me ................
>
> I have post this many times, but I did not get a close answer...........
>
> Pls write me
>
>
>
> Thanks in Advance,
>
>
>
>
>
>
>
>
>
>