Analysis By Dimension Filtering

bhareth

Hi,I have an issue on Analysis by dimensions on Financial Mangament,
where I want to filter to show only entries in an analysis view which have entries.


ie we list all the customers in the analysis view then filter on type "Area" as a dimension,
which only shows values for customers categorised as "Area".

but I want to hide all those which are blank i.e i am trying to hide customers with a zero value. .
Is there an easy way to do this

jannestig

You mean like Dimension filter <>'' ?

bhareth

jannestig,

I would like to show only the lines where the total amount is not equal to zero but i can't apply filter with success.
Has anybody got a solution ?

Thanks in advance

BHARETH.

ssingla

It is not possible.

bhareth

Thanks Singala ..

But i tired to write the follwoing piece of code on Find REC() and Next REC () function on form no Form 554 and it is working perfectly fine if

1. Show as lines for 'GL ACCOUNT' and show as colmuns as 'Period'.
2.Global dimensions 1 and 2.

GLAcc.SETFILTER("No.",GLAccFilter);
*********Code starts

IF DateFilter <> '' THEN
GLAcc.SETFILTER("Date Filter",DateFilter);
IF Dim1Filter <> '' THEN
GLAcc.SETFILTER("Global Dimension 1 Filter",Dim1Filter);
IF Dim2Filter <> '' THEN
GLAcc.SETFILTER("Global Dimension 2 Filter",Dim2Filter);
GLAcc.CALCFIELDS("Net Change");
GLAcc.SETFILTER("Net Change",'<>%1',0);

********* Code ends
Found := GLAcc.FIND(Which);


i need it to work for any combination of show as lines and colmuns filters as well as dimenision 3 and 4 filter ..

can you also suggest a suitable work aoround to achieve the solution

jannestig

Use the Analysis reports instead.

You can add the filters on the lines there

bhareth

Thanks jannestig..That must be a prompt solution for this issue .

jannestig

Yes on the lines on the sales & rec Analysis reports you have an option called show.

Set this to: If Any Column Not Zero

This will hide groups or customers when previewed or exported if any of the column totals do not contain a value different from 0