sum in BEx query

[Former Member]

Hi All,

I have Account and amount in my BEx query, Where accounts will start with X or Y or Z. user will enter any of the accounts.

In my output I want see X accounts (assumin that all accounts starting with X belongs to X group, Y belongs to Y group and so on) sum in one row and Y accounts amount sum one more row and so on...

I do not have account group in my flow and dont want to be derived in data flow based on account. Thanks

Please helpe me to achive the same .

Regards,

J B

[Former Member]

Resolved

[Former Member]

hi,

You can define 3 RKF which is built on amount and account.

in each the account restriction will change, the restriction will be on a range such as X00001 - X99999 , Y00000 - Y999999 etc.

Now create a structure for the report and use the created RKF's to show the data in format you want to show.

regards,

Arvind.

[Former Member]

Aravid,

Thanks for the quick response. Business dont want see in coloumns but in rows. After displaying Account-amount, business want to filter based on account group (meaning staring with X or Y or Z, whic is not directly present in Cube) instead account.

Regards,

J B

[Former Member]

hi,

as mentioned earlier after defining you can create struture to get the query output in the format you want.

But that will not be flexible, in case of flexible approach you will have to include the account group in the cube and load it with X,Y,Z.

regards,

Arvind.