Search results for query: *

Hey Guys - Let's talk about the query :) Here is the table: COLUMNS ARE AS SHOWN...VALUES ARE COMMISSION DOLLARS SLSREP YEAR JAN FEB MAR APRIL...........DEC JOHN 2010 2000 1000 2000 5000........3000 I imagine I need to read first column and see if it exceed the 100,000 cap then add next...

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...

Great. Works fine but I ran into situation where there are cases with no entry for revenue or cost. when I tried nullif(amount,0) on the amount I am still getting Null. I need it to be zero Thanks

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 =...

If I understand correctly does this mean I have to create a daily copy of the operation transaction database to a database lets say copy_operation and off of that create another database that would be like datawarehouse lets say reporting_datase with less joins for reporting? Is this correct. Bruce

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