Beyond 2020 twitterBeyond 2020 BlogBeyond 2020 Linkedinbeyond 2020 youtube

Tap in to your data’s intelligence

Beyond 20/20 Blog

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that has been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Login
Janet Smith

Janet Smith

Janet Smith has not set their biography yet

With the ability to build .ivt files from a comma separated file now available in the latest release of the Beyond 20/20 Builder (v7.1), now might be a good time to review the various types of source data that the B2020 Builder and DC Wizard accept.

 

Before considering your source files, you should have a clear understanding of how many .ivt files you want to build, the number of dimensions in each (and their general content), and what metadata should be associated with each Beyond 20/20 table.

 

You may have data in a bunch of different file formats or it may be stored in an existing database. If in a database, you should consider using the DC wizard which requires that you have a fact table where each record contains item keys (integers), item codes (characters), and at least one measure, or quantitative value. The DCWizard documentation outlines the steps required to build your tables.

...
Hits: 26831
Rate this blog entry: