Hi

I want to add the values of the cells column wise and row wise and
willing to show the result at the bottom of every column and the
rightmost side of every row of the cube via mdx query.

Is it possible in any way.

Regards

Harris

Hi

Yes this tool is basically connected with Microsoft Xml For Analysis
SDK and allows me to send any type of mdx quesries.And yes i can send
MDX Select statements

Regards,

Harris Moin


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Hey Tom

You said my problem can be solved with select statements.
Am waiting for your reply impatiently.

Regards,

Harris

Here's an example using foodmart:

WITH
SET Set1 AS '[Product Family].Members'
SET Set2 AS 'Store.USA.Children'
MEMBER Product.Total AS
' SUM(Set1, [Store Sales]) '
MEMBER Store.Total AS
' Sum(Set2, [Store Sales]) '
SELECT
{ Set1, Product.Total} ON axis(0),
{ Set2, Store.Total} ON axis(1)
FROM Sales

tom @ the domain below
www.tomchester.net


"Harris" <harris (AT) techlogix (DOT) com> wrote

Hi Tom

Thanx for your response. It realy does the trick but the thing is what
i was looking for is something more dynamic. Like just calculate the
values in the cells of the grid and give the total in the end.
Irrespective of what are the dimensions or the measures.

Something like i write a select statement and in the end write some
code to calculate the values in the columns and return there totals.

Thanx,

Harris



"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

It's semi-doable using the axis() function. The problems are: 1) the dim
that a calc belongs to can't be dynamic (except programmatically); 2) it
gets dicey when >1dim is on the axis. I don't have time today to flesh this
out for you.

tom @ the domain below
www.tomchester.net


"Harris" <harris (AT) techlogix (DOT) com> wrote

Hi

I have been able to find it's partial solution from one of these
forums. It works fine with adding the totals of the columns but since
i need to find the solution for both rows and columns. Am trying to
convert this query for that.But am facing with some errors. If you can
help me do that it will be great. The query is for foodmart 2000 as
follows:


with
member store.[] as 'null'
member Gender.Total As
'sum(Head(Axis(1),Axis(1).Count-1))',
solve_order=1
select
{[Measures].[Unit Sales]} on columns,
{CrossJoin({Gender.M,Gender.F},{USA.Children}),{(G ender.Total,Store.[])}}
on rows
from Sales

Regards,

Harris