Skip to Content
0
Former Member
Feb 04, 2014 at 01:59 AM

How to create three Blocks and make them repeat for each dimension in WEBI 4.0?

614 Views

Hello,

I work for a retail company and they have many STORES and employees assigned per each STATE per each COUNTRY.

Now, I need to show

Block 1 (Table) Activities Count by employees under each store for that STATE (STATE is an Optional Prompt - Multiple can be selected).

Block 2 (Table) Activities Count by Type of Store (High Rise, Low Rise etc)

Block 3 (Table) Activities Count by Weekday (Monday, Tuesday, etc).

The format needs to be like below:

Page 1 -

State 1:

Block 1 Summary

Block 2 Summary

Block 3 Summary

Page 2 -

State 2:

Block 1 Summary

Block 2 Summary

Block 3 Summary

------

-------

Page X -

State X:

Block 1 Summary

Block 2 Summary

Block 3 Summary

In words,

Instead of listing out all Counties in a Block 1 and then Block 2 and Block 3, I need to list page 1 with County 1 - (Block 1, Block 2, Block 3) and Page 2 with County 2 - (Block 1, Block 2, Block 3) and so on.

Any Suggestions on how to achieve this in WEBI would be much appreciated.

NOTE: I am using WEBI (BICS connection on top of a BeX query directly); ENV: BOBJ 4.0 SP8

Thanks,

RC

Attachments