Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Wiki Markup
{scrollbar}

----
Input sets allow you to group a 

...

Input sets allow you to group a model's

...

data

...

sources

...

in

...

sets.

...

Use

...

the

...

input

...

sets

...

as

...

alternatives

...

when

...

building

...

a

...

cube

...

corresponding

...

to

...

a

...

model.

...

Each

...

data

...

source

...

must

...

belong

...

to

...

at

...

least

...

one

...

input

...

set,

...

and

...

each

...

input

...

set

...

must

...

include

...

all

...

necessary

...

sources

...

for

...

a

...

complete

...

cube

...

build.

...

This

...

means

...

you

...

can

...

maintain

...

one

...

model

...

for

...

a

...

cube

...

and

...

build

...

it

...

from

...

more

...

than

...

one

...

environment.

...

For

...

example,

...

with

...

a

...

Development

...

input

...

set

...

and

...

a

...

Production

...

input

...

set,

...

file

...

formats

...

or

...

queries

...

used

...

to

...

retrieve

...

data

...

can

...

move

...

from

...

the

...

development

...

environment

...

to

...

the

...

production

...

environment.

...

This

...

feature

...

facilitates

...

use

...

of

...

more

...

than

...

one

...

input

...

set

...

for

...

a

...

single

...

model.

...

When

...

you

...

build

...

the

...

cube

...

you

...

identify

...

the

...

input

...

set

...

to

...

use.

...

You

...

can

...

define

...

two

...

types

...

of

...

input

...

sets:

...

  • Full

...

  • :

...

  • The

...

  • cube

...

  • is

...

  • completely

...

  • built

...

  • as

...

  • if

...

  • was

...

  • the

...

  • first

...

  • time,

...

  • regardless

...

  • of

...

  • the

...

  • data

...

  • loaded

...

  • in

...

  • previous

...

  • buildings.

...

  • Incremental

...

  • :

...

  • The

...

  • cube

...

  • is

...

  • built

...

  • by

...

  • adding

...

  • the

...

  • data

...

  • that

...

  • will

...

  • be

...

  • read

...

  • from

...

  • the

...

  • indicated

...

  • entry

...

  • data.

...

  • The

...

  • designer

...

  • is

...

  • responsible

...

  • for

...

  • making

...

  • sure

...

  • that

...

  • this

...

  • set

...

  • has

...

  • only

...

  • the

...

  • data

...

  • that

...

  • is

...

  • to

...

  • be

...

  • added.

...

(warning) Note
To perform an incremental build you must define an incremental input set. Whenever you define an incremental build, an input set for a full build must also exist.

To define an input set

  1. Select the cube's branch in the Design tree. The Properties pane for the cube displays.
  2. Choose the add an input set, choose the Add button in the Input Sets group box.
  3. To edit the input set name, double-click on the Name field.
  4. Enter the new input set name.
  5. To change the input set type, double-click on the Type field. The list of types displays.
  6. Select a type. The Type field updates.

Image Added

Assigning Data Sources to Input Sets

Use the InputSets page of the Data Sources property pane to assign a data source to an input set.

To assign a data source to an input set:

  1. Select the data source's branch in the Design tree. The Properties pane for the data source displays.
  2. Choose the InputSets page. A list of input sets displays.
  3. Turn on the checkbox for each input set to include the data source in.

Image Added

(warning) Note
Data sources include text data, SQL queries and guards.
You must define the input set for the cube before you can assign a data source to it.
Each data source must belong to one or more input sets.
You must assign at least one data source to each input set. If you do not assign an input set, the Full input is is the default during the build.
You must explicitly save the cube definition, otherwise changes apply only to the opened model.

...

Wiki Markup
{scrollbar}
Child pages (Children Display)