This website is not affiliated with, sponsored by, or approved by SAP AG.

How do I have to configure my company Fiscal Year Data in BW

Business Warehouse

Moderators: Snowy, thx4allthefish

How do I have to configure my company Fiscal Year Data in BW

Postby mvontik » Wed May 23, 2012 8:06 pm

Hi ,

I am a beginner to SAP BW.In my company we maintain Fiscal calendar in a table.I have to create reports based on that table data.How do I have to bring that table into SAP BW.Basically we do reports on Fiscal Date , Fiscal Month etc..

I am thinking of saving data into .csv file and transfer that data into BW.I am not sure whether it possible.Appreciate if some body give me some direction on this.

Basically users compare data, year over year ,and 13 weeks this year to 13 weeks last year and some times reports based on Date.

Thanks
MV
Last edited by Gothmog on Thu May 24, 2012 1:46 am, edited 1 time in total.
Reason: Urgency removed
mvontik
 
Posts: 2
Joined: Wed May 23, 2012 7:44 pm

Re: How do I have to configure my company Fiscal Year Data in BW

Postby djbenice » Thu May 24, 2012 3:32 am

Just extract the relevant charcteristics ie 0fiscper 0fiscyear 0calmonth etc they are standard.
djbenice
 
Posts: 50
Joined: Mon Jan 16, 2006 6:51 am

Re: How do I have to configure my company Fiscal Year Data in BW

Postby mvontik » Thu May 24, 2012 7:08 am

Thank you djbenice. But how does system know my Fiscal calendar starts on certain day.For instance 2011 started on Jan 2nd and 2012 on Jan 1st.

Thanks
MV
mvontik
 
Posts: 2
Joined: Wed May 23, 2012 7:44 pm

Re: How do I have to configure my company Fiscal Year Data in BW

Postby djbenice » Fri Jun 01, 2012 2:56 am

Sorry I assumed you were using SAP as a source system, within ECC/R/3 you maintain the fiscal calendar (txn spro from memory) What is your data source?
djbenice
 
Posts: 50
Joined: Mon Jan 16, 2006 6:51 am

Re: How do I have to configure my company Fiscal Year Data in BW

Postby djbenice » Fri Jun 01, 2012 2:58 am

Ah just noticed the original post changed, flat file extraction is possible in BW, very straight forward, if you look at the extractorin your BW system for the calendar data you should be able to ascertain the structure of your flat file from there :mrgreen:
djbenice
 
Posts: 50
Joined: Mon Jan 16, 2006 6:51 am


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 4 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.