Component Solution Services REC02F Manual de usuario descargar pdf (Pagina 27)

Tips Recipes Brio 2002

Section Type: Results or Table section

Tip Name: Analyzing “factless” data

Purpose / Use: Some data sets do not have any obvious fact columns. For example,

qualitative data sets are collections of ratings or item types. Brio

Intelligence can still be used to analyze these data sets with a simple

concept applied to the Results section.

Sample File: Factless data.bqy

Steps to Produce: To analyze “factless” data, you merely need to create a computed fact

based on the dimensions present.

1) In the Results section, create a Computed Item named “Store Cnt”. Set the formula for this

computed item to be:

Yes, create a computation with the simple formula of the number one.

2) Use this new “fact” in any chart, pivot or report to analyze the number of occurrences of

each of the items in your query.

1 2 ... 22 23 24 25 26 27 28 29 30 31 32 ... 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 27