Since last 7 days i am facing a problem when I excute a report.Her I am giving you details.
I developed an Infoset by taking 2 standard infocubes(0RT_C02 & 0FIAP_C03 ).after that i developed a query depend upon that Infoset.In the quey my requirements are like this.
1). In Rows I took vendor,business area and posting date.
2). In columns,Debit amountLC and Credit amountLC
3). In filter,Brand and Family.
in the above formate i created a query.but my problem is,when i excute this without using any drill downs ( filter values )the quey output is fine.But when ever i drill down Brand or Family from filter some records are showing same values.And one thing in this quey i didn't use any restrictions and formulas
please suggest me how can i avoid this problem.
Thanks & Regarsd