Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In source file preview data mapping screen you can enter data cube name where you would like to import your data. If this is new data set then enter new cube name (e.g. Sales cube if you are importing sales transactions). You can also import new file in existing data cube - in this case you can use either existing cube dimensions and measures or specify new ones (which will be added to existing cube during import).

It is recommended that CSV file has header row with column names - eazyBI will flex.bi will try to detect if your CSV file has header row or not. If eazyBI flex.bi has detected it incorrectly then please change number of header rows (e.g. specify 0 if you do not have any header row).

eazyBI will flex.bi will try to detect each source file column data type based on first 100 rows of source file. Detected column types (stringinteger,decimaldate or datetime) are shown below each column name. If some column type is detected incorrectly then you can change it (e.g. change from integer to string if this column might contain also non-integer values).

...

Next you need to map source file columns to cube dimensions and measures.

By default eazyBI will flex.bi will suggest to map string columns to dimension with name which is derived from column name (underscores replaced with spaces, each word is capitalized). If necessary then you can enter different dimension name that you would like to use in eazyBIflex.bi.

You can map each column to separate dimension but sometimes it would be better to map several columns to the same dimension but different hierarchy levels. E.g. in this example it would be better to map countrystate_provincecity and fullname to the same Customers dimension with hierarchy levels Country (highest hierarchy level), State Province (one country expands to several states or provinces), City (one state or province expands to several cities), Customer Name (one city expands to several individual customers). It is important that in source file hierarchy level columns are always in the sequence from highest hierarchy level to lowest hierarchy level.

...

You should use one of the following date formats in your CSV file that eazyBI flex.bi will recognize as date format and you will be able to import it as Time dimension:

...