How to design muti-display in query? thanks

[Former Member]

Hi, Experts

I want to know how to design query like that(By product):

CHAR:product

KF:P/O,Ship.Total Sales,inventory

-

---

Week1 Week2

Product A P/O 70 60

Product A Ship 60 75

Product A Total Sales 80 70

Product A Total Inventory 170 175

-

---

Week1 Week2

Product B P/O 60 50

Product B Ship 50 65

Product B Total Sales 80 70

Product B Total Inventory 170 175

-

---

....

Thanks,

[Former Member]

Thanks all,

I am working on cube designing now. you don't need think about infoprovider and structure. I focus on how to accomplish the muti-display base on product.

Which must need VBA or not? If so, how?

[jaya_mogali]

Hi Sam,

If you are designing stage then create three cubes

one each for Inventory, Sales and PO data.

Then create a multiprovider.

You can create a your report using structures in your query.

VBA is not required

Jaya

[Former Member]

Thanks Jaya,

I almost finished the muticube, I just want to know how to display the report by each product. the tricky is muti-display, do u have any idea?

Thanks

[jaya_mogali]

Hi Sam,

In your query keep . Week1 and Week 2 in Columns

In Rows keep Product below prodct add a structure.

The first selection will be Purchase order quantity. Restrct this by PO Infocube

Second will be Shipping Quantity > restricted by sales cube.

Similarly create lines for Inventory and Sales.

In multiprovider Identification you should map the product and Week1 from all the cubes.

Jaya

[Former Member]

Jaya,

Just focus on mutidisplay, I want to get separate report by diffrent product. every product has their separate form. I never see that kind report before. for cognos it is easier,but how to do that in bw?

[Former Member]

Hi Sam,

Can you be more specific as in what you really mean by "separate report by diffrent product".

Do you want your report to display depending on the product you enter as char or do you want a single report to display the details of product 1 first with the result followed by product 2?

Rad.

[Former Member]

Thanks Rad,

I want to get the report like this:

-

---

Product A P/O 70 60

Product A Ship 60 75

Product A Total Sales 80 70

Product A Total Inventory 170 175

-

---

Product B P/O 60 50

Product B Ship 50 65

Product B Total Sales 80 70

Product B Total Inventory 170 175

-

---

Product C P/O 60 50

Product C Ship 50 65

Product C Total Sales 80 70

Product c Total Inventory 170 175

-

---

.......

Base on same infoprivoder,same 'product' char and KF.

[Former Member]

did you try creating a Query like below... give a try...

Rows: Product IO

Strcture which all KF IO's.

Colomns: Weeks IO.

Let me know if it helps.

Nagesh Ganisetti.

• Assign points if it helps.

[Former Member]

would you be more elaborate with the query strcuture you have mentioned: what are the chars and how are the KF's being derived in ur report. It helps to be more elaborate

[Former Member]

If I am interpreting your report correctly, you are trying to put Purchasing, Shipping, Sales and Inventory data all in one report.

The rule with BW/BI is you get one and only one InfoProvider per query, so unless you want to do VBA macros in an Excel worksheet or something like that, you will have to get all these diverse sources of data combined into one InfoProvider first. Good luck with that!

As Voodi said, if you will provide more details of what you are trying to accomplish, we may be able to provide more useful suggestions...

Bob