Hi, I want to know how to create driver based reporting in R12. My requirement is to have all the drivers in the column and cost for it for any given object. I see there is a label field named "Drivers" for each modeled object and I am able to pull Drivers into "Rows" section of Ad Hoc Component Configuration, but I am not to pull "Drivers" into "Columns" section of "Ad Hoc Component Configuration". Can you please let me know ho we can achieve this.#driver based report in R12

Hi @Sangeetha AR,

The best way to do this would be to create a Formula Column using the Insert tool in the Data tab. From here you will be prompted to enter the name of your Formula Column and its formula- if you start typing the name of the object your driver is originating from the Formula should autocomplete with the format " ={Object (Cost driver) }".

Remember to set the Format of your Formula Column to Currency and tick the "Summable" box at the bottom if applicable and you should be able to report on your drivers in separate columns from the same table. For more information on Formula Columns please see this article.

Best regards,

Thank you Michael. we will try this and get back to you for any questions.

Michael, can you please let me know whether driver based report will work if we combine two different objects? for ex, i want to combine Cost Source and Applications object and want to have drivers for applications object.

Hi Sangeetha,

In this example the driver formula would not work, and in general it is not best practice to create a table combining objects from the top and the bottom of the model as this can have a large impact on your calculation times.

I would recommend using the LookupObjectUnitValue formula instead, and either using the formula to pull in the values you need or creating a new model object for your report and using LookupObjectUnitValue for the driver.

Best regards,