cancel
Showing results for 
Search instead for 
Did you mean: 

creating report based on master data

Former Member
0 Kudos

Hi Guys,

I want to create a specific report based on master data in BI cube. for example... a report which takes cost center and period as variable and display expenses for that period and cost center. This report I want to create for all cost center in BI database separately. any idea how can we do this?

There are 2000 cost centers and I need to print/send 2000 reports one for every cost center.

If I store all cost center in excel file, can it be easier?

broadcasting and creating 2000 schedule - not option.

Thanks..SM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi stuti misra,

Create ONE Query with selection Cost Center and Period are inputs.

Create text variables for Cost Center and Period and add in Query Description.

After query execution you can see description based on selection in workbook or webtemplate.

Hope it Helps

Srini

[Dont forget to close the call by assigning poings.... - Food for Points: Make a Difference through Community Contribution!|https://www.sdn.sap.com/irj/sdn/index?rid=/webcontent/uuid/007928c5-c4ef-2a10-d9a3-8109ae621a82]

Former Member
0 Kudos

I have already query for one cost center based on period as input...

how do I execute this 2000 times taking cost center as input from master data?

Former Member
0 Kudos

stuti misra,

Try to create an ABAP program to execute or broadcast query by looping different variants.

Check any standard function module available for executing or boradcasting. I dont have system now...

Srini

Former Member
0 Kudos

Srini, Thx for response., do not have we have SAP stanadard option to execute report based on 0costcenter Master Data as input?

this seems to be so general need.

Former Member
0 Kudos

IF you are running BI 7.0 ,look at the Information Broadacasting "Bursting" feature.

Former Member
0 Kudos

bursting is useful...when distributing same report to multiple people based on values in master data.

my problem is other way... generating different reports based on master data as input!

Edited by: stuti misra on Nov 19, 2008 2:45 AM

Edited by: stuti misra on Nov 19, 2008 2:46 AM

Former Member
0 Kudos

folks, any idea if we have list of cost centers in excel file... can we run report one by one thru some batch scheduling and create report for different cost centers?

basiccaly read input parameters from some data storage - file or table and create report one by one.

broadcasting option is not suitable...