Need a Report - Puchase Orders Region (0country) wise from Cube 0PUR_C04

[Former Member]

Hi I need a Report From the Cube 0PUR_C04 (Business content Cube)

Report for Technical Services / Materials Activities

<b>Puchase Orders Region (0country) wise</b>

No of Purchase Orders--

---

Year 2005Month DEC --Cumulative Year 2006

Asia (India,china,japan)--

---

200

---

40--

---

600

Europe(UK,Germany,France,Italy)---300

---

60--

---

900

Africa (south africa,zimbabve,kinya)-100

---

35--

---

850

others (other countries)--

---

800

---

90--

---

1580

<b>Value of Purchase orders(In Dollers)</b>

Asia (India,china,japan)--

---

1200

---

240--

---

8600

Europe(UK,Germany,France,Italy)---1300

---

260--

---

8900

Africa (south africa,zimbabve,kinya)-1100

---

235--

---

8250

others (other countries)--

---

1800

---

290--

---

81580

0COUNTRY is Attribute of 0VENDOR(characteristic)

0COUNTRY is a Navigational Attribute

How to do this Report any Idea.

Can anybody Help me to solve this Report.

Thanks in Advance

prasanna

[Former Member · Accepted solution]

Based on your example, I assume that your problem is the grouping of the countries into continents. If so, one way to do this would be to create a hierarchy for 0COUNTRY in BW.

Another way would be to add Continent as a new attribute of 0VENDOR, then make it a navigational attribute and report by it instead of (or in addition to) 0COUNTRY.

Hope this helps...

Bob

[Former Member]

In Addition to what has been recommended. If you don't want to create hierarchy, and you know the countries in for each Division(Asia, Europe...) then you can create a structure. The only problem with this is if there is a new country is added to one of the divisions then you need to make the changes in the query. The same is true for the hierarchy.

thanks.

Wond

[Former Member]

Thank you Bob & wond for the Responce.

wond can you please explain in Brief, I didn't get your point.

like <b>how to create the structure</b> for my Requirement step by step.

My cube is 0PUR_C04 (Business Content Cube), no changes are there in the cube, what SAP is delevered i am using that.

Thanks

prasanna

[Former Member]

Hi Friends,

You have any Idea How to create a Region wise Report For 0PUR_C04.

0COUNTRY is a Navigational Attribute of 0VENDOR.

Thanks

prasanna

[former_member185071]

Hi prasanna

Just have a look @ the following report

<u><b><a href="http://help.sap.com/saphelp_nw70/helpdata/en/a2/bfa937a7777c38e10000009b38f842/frameset.htm">REPORT</a></b></u>

Hope itz clear a little atleast...!

Thanks & Regards

R M K

**Winners dont do different things,they do things differently**

> Hi Friends,

>

> You have any Idea How to create a Region wise Report

> For 0PUR_C04.

> 0COUNTRY is a Navigational Attribute of 0VENDOR.

>

> Thanks

> prasanna

[Former Member]

Hi any body know how to do this Report.

Thanks

prasanna

[Former Member]

Hi any body know how to do Region wise Report.

Thanks

prasanna