Hai

a part of our business users use InfoAssist to analyze data, make reports etc.. And they are very happy with it.
We therefore create business views for them.
Almost every business view consists of detailrecords from a fact table, for instance creditcard transactions, and we then join all the necessary dimensions to this fact table.
So we somehow flatten the fact table.

In earlier days there was the dimension view, which we never used.
Now, in Infoassist+, there is the business view+.

With this it seems to be able to construct a business view in which you can automatically drill up and down?
So you can also use this view to drill up and down in a report or graph?

Where can I find detailed information on this?

Regards
Ron

This message has been edited. Last edited by: FP Mod Chuck,

Ronibi

Here is a link to a manual. Chapter 3 is all about metadata and there is a section on business views etc.

https://webfocusinfocenter.inf...ent/pdfs/as_user.pdf

Thnx Chuck, although I was hoping for some figured out example

regards
Ron

Ronibi

This is a partial sample of the WF_RETAIL master file. Notice PRODUCT_CATEGORY and PRODUCT_SUBCATEG, and MODEL and the use of the WITHIN statement. WITHIN='*Hierarchy13' defines the beginning of a drill path.


SEGMENT=WF_RETAIL_PRODUCT, CRFILE=wfretail82/DIMENSIONS/WF_RETAIL_PRODUCT, CRINCLUDE=ALL,
DESCRIPTION='Product Dimension', $
PARENT=WF_RETAIL_SALES, SEGTYPE=KU, CRJOINTYPE=LEFT_OUTER,
JOIN_WHERE=WF_RETAIL_SALES.ID_PRODUCT EQ WF_RETAIL_PRODUCT.ID_PRODUCT;, $
PARENT=WF_RETAIL_SHIPMENTS, SEGTYPE=KU, JOIN_TYPE=LEFT_OUTER,
JOIN_WHERE=WF_RETAIL_SHIPMENTS.ID_PRODUCT EQ WF_RETAIL_PRODUCT.ID_PRODUCT;, $
FIELDNAME=&&ID_PRODUCT,
PROPERTY=VARIABLE, $
FIELDNAME=ID_PRODUCT,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=BRAND,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=BRANDTYPE,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=MODEL,
WITHIN=WF_RETAIL_PRODUCT.PRODUCT_SUBCATEG, $
FIELDNAME=PRICE_DOLLARS,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRICE_RANGE_HL,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRICE_RANGE_NUM,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRODUCT_CATEGORY,
WITHIN='*Hierarchy13', $
FIELDNAME=PRODUCT_COST,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRODUCT_DESCRIPTION,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRODUCT_NAME,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRODUCT_SUBCATEG,
WITHIN=WF_RETAIL_PRODUCT.PRODUCT_CATEGORY, $
FIELDNAME=PRODUCT_WEIGHT,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRODUCT_WEIGHT_UNITS,
REFERENCE=WF_RETAIL_PRODUCT.MODEL, PROPERTY=ATTRIBUTE, $
FIELDNAME=PRODUCT_PROMPT,
PROPERTY=FILTER, $
FIELDNAME=ACCESSORIES,
PROPERTY=FILTER, $
FIELDNAME=DISCONTINUED,
PROPERTY=FILTER, $


Hope this helps