GENERATING DYNAMIC DRILLDOWN REPORTS

1 . A computer implemented method for generating a child drilled report corresponding to a parent drill-down report, the method comprising:

receiving, at a user interface, a drilldown request for a data value included in the parent drilldown report;

identifying, by a processor of the computer, an attribute of the data value included in the parent drilldown report;

determining, by the processor of the computer, an associated attribute corresponding to the identified attribute from an in-memory database attribute relationship table stored in an in-memory database;

based on the data value and the associated attribute, searching, by the processor of the computer, one or more database tables, stored in the in-memory database, to retrieve one or more data values corresponding to the determined associated attribute; and

generating, by the processor of the computer, the child drilled report including the retrieved one or more data values.

2 . The computer implemented method according to claim 1 , further comprising:

receiving, at the user interface, a drilldown request for one of the one or more data values included in the child drilled report;

identifying, by the processor of the computer, an attribute of the one of the one or more data values included in the child drilled report;

determining, by the processor of the computer, an associated attribute corresponding to the identified attribute from the in-memory database attribute relationship table stored in the in-memory database;

based on the one of the one or more data values and the associated attribute, searching, by the processor of the computer, the one or more database tables, stored in the in-memory database, to retrieve one or more data values corresponding to the associated attribute; and

generating, by the processor of the computer, a grandchild drilled report including the retrieved one or more data values.

3 . The computer implemented method according to claim 2 , further comprising:

displaying, at the user interface, the parent drilldown report, the child drilled report, and the grandchild drilled report in a tabbed view on a single screen.

4 . The computer implemented method according to claim 1 , further comprising:

at a source in-memory database model, receiving a selection of a drillable attribute from a plurality of attributes displayed at the source in-memory database model;

at a drill down property section, corresponding to the selected drillable attribute, included in the source in-memory database model, receiving a selection of a target in-memory database model including one or more associated attributes corresponding to the drillable attribute;

storing the source in-memory database model in the in-memory database; and

activating, by the processor of the computer, the source in-memory database model, wherein the activated source in-memory database model includes a relationship between the drillable attribute and the target in-memory database model.

5 . The computer implemented method of claim 4 , wherein activating the in-memory database model includes:

storing the activated source in-memory database model, the drillable attribute, the target in-memory database model, and the one or more associated attributes, corresponding to the drillable attribute, in the in-memory database attribute relationship table.

6 . The computer implemented method according to claim 4 , further comprising:

at the drilldown property section, receiving a selection of an attribute from the one or more associated attributes included in the target in-memory database model; and

storing the selected attribute in the in-memory database attribute relationship table.

7 . The computer implemented method according to claim 4 , further comprising:

highlighting the drillable attribute included in the drilldown report.

8 . A computer system for generating an in-memory database application in communication with an in-memory database, the computer system comprising:

a memory to store a program code; and

a processor communicatively coupled to the memory, the processor configured to execute the program code to:

receive, at a user interface, a drilldown request for a data value included in the parent drilldown report;

identify an attribute of the data value included in the parent drilldown report;

determine an associated attribute corresponding to the identified attribute from an in-memory database attribute relationship table stored in an in-memory database;

based on the data value and the associated attribute, search one or more database tables, stored in the in-memory database, to retrieve one or more data values corresponding to the determined associated attribute; and

generate the child drilled report including the retrieved one or more data values.

9 . The system of claim 8 , wherein the processor further executes the program code to:

receive a drilldown request for one of the one or more data values included in the child drilled report;

identify an attribute of the one of the one or more data values included in the child drilled report;

determine an associated attribute corresponding to the identified attribute from the in-memory database attribute relationship table stored in the in-memory database;

based on the one of the one or more data values and the associated attribute, search the one or more database tables, stored in the in-memory database, to retrieve one or more data values corresponding to the associated attribute; and

generate a grandchild drilled report including the retrieved one or more data values.

10 . The system of claim 9 , wherein the processor further executes the program code to:

display, at the user interface, the parent drilldown report, the child drilled report, and the grandchild drilled report in a tabbed view on a single screen.

11 . The system of claim 8 , wherein the processor further executes the program code to:

at a source in-memory database model, receive a selection of a drillable attribute from a plurality of attributes displayed at the source in-memory database model;

at a drill down property section, corresponding to the selected drillable attribute, included in the source in-memory database model, receive a selection of a target in-memory database model including one or more associated attributes corresponding to the drillable attribute;

store the source in-memory database model in the in-memory database; and

activate the source in-memory database model, wherein the activated source in-memory database model includes a relationship between the drillable attribute and the target in-memory database model.

12 . The system of claim 11 , wherein the processor further executes the program code to:

store the activated source in-memory database model, the drillable attribute, the target in-memory database model, and the one or more associated attributes, corresponding to the drillable attribute, in the in-memory database attribute relationship table.

13 . The system of claim 11 , wherein the processor further executes the program code to:

at the drilldown property section, receive a selection of an attribute from the one or more associated attributes included in the target in-memory database model; and

store the selected attribute in the in-memory database attribute relationship table.

14 . The system of claim 11 , wherein the processor further executes the program code to:

highlight the drillable attribute included in the drilldown report.

15 . An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:

receive, at a user interface, a drilldown request for a data value included in a parent drilldown report;

identify an attribute of the data value included in the parent drilldown report;

determine an associated attribute corresponding to the identified attribute from an in-memory database attribute relationship table stored in an in-memory database;

based on the data value and the associated attribute, search one or more database tables, stored in the in-memory database, to retrieve one or more data values corresponding to the determined associated attribute; and

generate a child drilled report including the retrieved one or more data values.

16 . The article of manufacture of claim 15 , further comprising instructions which when executed by the computer further causes the computer to:

receive a drilldown request for one of the one or more data values included in the child drilled report;

identify an attribute of the one of the one or more data values included in the child drilled report;

determine an associated attribute corresponding to the identified attribute from the in-memory database attribute relationship table stored in the in-memory database;

based on the one of the one or more data values and the associated attribute, search the one or more database tables, stored in the in-memory database, to retrieve one or more data values corresponding to the associated attribute; and

generate a grandchild drilled report including the retrieved one or more data values.

17 . The article of manufacture of claim 16 , further comprising instructions which when executed by the computer further causes the computer to:

display, at the user interface, the parent drilldown report, the child drilled report, and the grandchild drilled report in a tabbed view on a single screen.

18 . The article of manufacture of claim 15 , further comprising instructions which when executed by the computer further causes the computer to:

at a source in-memory database model, receive a selection of a drillable attribute from a plurality of attributes displayed at the source in-memory database model;

at a drill down property section, corresponding to the selected drillable attribute, included in the source in-memory database model, receive a selection of a target in-memory database model including one or more associated attributes corresponding to the drillable attribute;

store the source in-memory database model in the in-memory database; and

activate the source in-memory database model, wherein the activated source in-memory database model includes a relationship between the drillable attribute and the target in-memory database model.

19 . The article of manufacture of claim 18 , further comprising instructions which when executed by the computer further causes the computer to:

store the activated source in-memory database model, the drillable attribute, the target in-memory database model, and the one or more associated attributes, corresponding to the drillable attribute, in the in-memory database attribute relationship table.

20 . The article of manufacture of claim 18 , further comprising instructions which when executed by the computer further causes the computer to:

at the drilldown property section, receive a selection of an attribute from the one or more associated attributes included in the target in-memory database model; and

store the selected attribute in the in-memory database attribute relationship table.