Search results for query: *

Hi all, I am trying to create a query that will calculate a sales commission and reset the commission to zero if the YTD commission reach certain dollar Cap. For example I have an invoice table that has invnumber salesrep invamount Assume that salesrep get 2% of invoice AMT as a commission per...

Hi all, I am trying to build a query that calculate gross margin. The GM = (revenue-cost)/Revenue The issue is the revenue and cost are in same table but different record. e.g. table 1 account type amount 1001 revenue 1000000 1001 Cost 500000 so I need to calculate GM =...

Hi all, I am planning to use Cognos to create reports for our finance group. I want to get some views whether I should use the financial database as the data source or should I create a new database only for reporting where I copy the desired tables into it. The requirement are to drill down to...

Hi There, I am considering creating a reporting database for our financial group to allow them to slice and dice data from various views. This database will combine data from HR, finance and operation. My question is the type of analysis needed is down to the Line details level. Does this mean...

Hi there, Is anyone using SAP BusinessObjects Financial Information Management tool to load and extract data from Magnitude. I am looking into someone who can share his experience with the tool and provide best approach to load/extract data Thanks Sam