As an InfoAssist user I like to see Dimensions and Metrics in the correct section so that it is clear what's a metric and what's a dimension.

Can you please give me a example how to make separate fields showing in InfoAssist (Dimension and Metric Fields)

This message has been edited. Last edited by: <Kathryn Henning>,

IA breaks you fields into sections assuming that any numeric field is a metric. If you have numeric dimensions then they will show up in metrics. You could convert numeric dimension fields to Alpha type in the MFD and hide the original fields.

Thanks for your inputs also if you provide an example it will be great.....

I've had very limited experience with IA and actually find it quite irritating to have the dimensions and measures separated and not displayed in the traditional segmented view. I was trying to teach some users how to create a report and trying to explain to them what the data structure actually looks like is very difficult when fields in parent and child segments are all jumbled up together.

By default, dates and alphanumerics will be displayed as dimensions in the Data pane in IA, and numerics will display as measures.

If you don't like that view, select the View tab, and select a different view from the Data Panel group... Logical shows fields in dimensions and measures; List shows fields in a straight list (which you can alphabetize by clicking the fieldname heading); Structured show fields in a segmented view directly from the Master.

Thanks for the inputs.

Can I have an example how to make separate fields showing in InfoAssist (Dimension and Measure Fields)

jsn22,

Look in the documentation for metadata (DN4501042.1013 page 168 - 173). There is a section on WITHIN on how to create dimensions in the master file. I believe it is only since release 8 (I could be wrong as I haven't done a lot of work with IA prior to 8) that InfoAssist has smart context to know that alphanumerics and date fields are dimensions and numerics are measures. I am thinking prior to 8 you had to declare them in the metadata. Check out the doc... there is an example of there of what a master looks like using WITHIN.