2
.. i18n: Goal of Cube Designer
3
.. i18n: =====================
9
.. i18n: The goal is to develop a User Friendly Cube Designer for Open Object - BI that allows a user to define and / or modify an OLAP cube definition starting from any database. (Oracle, MySQL, PostgreSQL). This has to be user friendly so that a end-user can define his own cube on his own database without any development knowledge.
12
The goal is to develop a User Friendly Cube Designer for Open Object - BI that allows a user to define and / or modify an OLAP cube definition starting from any database. (Oracle, MySQL, PostgreSQL). This has to be user friendly so that a end-user can define his own cube on his own database without any development knowledge.
14
.. i18n: Basic features
15
.. i18n: --------------
21
.. i18n: The cube designer of the OpenObject – BI Solutions helps users create new cubes and modify existing ones. Once the user is connected to the database they can create cubes in two ways
23
.. i18n: #Generic Flow.
26
The cube designer of the OpenObject – BI Solutions helps users create new cubes and modify existing ones. Once the user is connected to the database they can create cubes in two ways
37
.. i18n: In the wizard flow a wizard guides the user through the entire process of cube creation. Navigation can be done through Next and Previous button.
40
In the wizard flow a wizard guides the user through the entire process of cube creation. Navigation can be done through Next and Previous button.
43
.. i18n: Clicking on the “Save” button on every form causes the data to be written in the database and simultaneously the “Next” button is activated and the user is navigated to the next form.
44
.. i18n: Next button will not be activated until the data is “Saved”.
48
Clicking on the “Save” button on every form causes the data to be written in the database and simultaneously the “Next” button is activated and the user is navigated to the next form.
49
Next button will not be activated until the data is “Saved”.
58
.. i18n: The cube can be modified / created by the user in a normal way.
61
The cube can be modified / created by the user in a normal way.
63
.. i18n: :Modify / Create A Schema:
66
:Modify / Create A Schema:
68
.. i18n: The user specifies the desired schema name.
69
.. i18n: They select the desired database or create it with the help of [new].
70
.. i18n: They specify the schema description.
71
.. i18n: They save the schema.
74
The user specifies the desired schema name.
75
They select the desired database or create it with the help of [new].
76
They specify the schema description.
79
.. i18n: :Modify / Create A Fact Table:
82
:Modify / Create A Fact Table:
84
.. i18n: User makes a particular Type for Fact table
85
.. i18n: They select the desired database or Schema for a particular Fact Table, or create one using the [new] button.
87
.. i18n: :Modify / Create A Database:
90
User makes a particular Type for Fact table
91
They select the desired database or Schema for a particular Fact Table, or create one using the [new] button.
93
:Modify / Create A Database:
95
.. i18n: User specifies the “General Parameters”
96
.. i18n: He specifies the “Connection Parameters” that specify which database and port number will be used for the connection.
97
.. i18n: He tests the connection for error and the “Connection URL” is generated.
98
.. i18n: On connection string being correct the new database is created.
101
User specifies the “General Parameters”
102
He specifies the “Connection Parameters” that specify which database and port number will be used for the connection.
103
He tests the connection for error and the “Connection URL” is generated.
104
On connection string being correct the new database is created.
106
.. i18n: :Modify / Create A Cube:
109
:Modify / Create A Cube:
111
.. i18n: The user provides desired cube name along with the fact tables and schema name.
112
.. i18n: The user can select previously created fact tables via a drop down box or can create a new fact table by clicking on [new].
113
.. i18n: Same goes for schema too.
114
.. i18n: The dimensions and measures will be empty as they have not yet been created.
117
The user provides desired cube name along with the fact tables and schema name.
118
The user can select previously created fact tables via a drop down box or can create a new fact table by clicking on [new].
119
Same goes for schema too.
120
The dimensions and measures will be empty as they have not yet been created.
122
.. i18n: :Modify / Create A Dimension:
125
:Modify / Create A Dimension:
127
.. i18n: The user provides the dimension name.
128
.. i18n: The given cube name will appear in the drop down box. They can select a cube name from the list or create a new cube by clicking on [new].
129
.. i18n: Hierarchies are absent.
132
The user provides the dimension name.
133
The given cube name will appear in the drop down box. They can select a cube name from the list or create a new cube by clicking on [new].
134
Hierarchies are absent.
136
.. i18n: :Modify / Create A Hierarchies:
139
:Modify / Create A Hierarchies:
141
.. i18n: The user provides the hierarchy name.
142
.. i18n: The dimension name will come in the dropdown box.
143
.. i18n: User can create a new dimension by clicking on [new].
144
.. i18n: User will provide the hierarchy field name, sequence, hierarchy type, all member and default member fields.
145
.. i18n: User will give the fact table by selecting it from a drop down box or by creating a new fact table altogether by clicking on [new]
148
The user provides the hierarchy name.
149
The dimension name will come in the dropdown box.
150
User can create a new dimension by clicking on [new].
151
User will provide the hierarchy field name, sequence, hierarchy type, all member and default member fields.
152
User will give the fact table by selecting it from a drop down box or by creating a new fact table altogether by clicking on [new]
154
.. i18n: :Modify / Create A Levels:
157
:Modify / Create A Levels:
159
.. i18n: The user has to specify the level name, column name, column id, level class, table name, sequence and hierarchy.
160
.. i18n: Hierarchy will appear in the drop down box.
161
.. i18n: He can create a new hierarchy by clicking on [new].
164
The user has to specify the level name, column name, column id, level class, table name, sequence and hierarchy.
165
Hierarchy will appear in the drop down box.
166
He can create a new hierarchy by clicking on [new].
169
.. i18n: Clicking on the "Save" button on every form causes the data to be written in the database.
170
.. i18n: Double Click on row opens modification window of respective record.
174
Clicking on the "Save" button on every form causes the data to be written in the database.
175
Double Click on row opens modification window of respective record.
177
.. i18n: :Modify / Create A Measures:
180
:Modify / Create A Measures:
182
.. i18n: The user provides the Measure name.
183
.. i18n: The given cube name will appear in the drop down box. They can select a cube name from the list or create a new cube by clicking on the [new].
184
.. i18n: It defines the all calculation / aggregation with fact column name.
185
.. i18n: Here all calculation / aggregation are interdependent with the fields of fact column name, aggregator, data type and format of string.
188
The user provides the Measure name.
189
The given cube name will appear in the drop down box. They can select a cube name from the list or create a new cube by clicking on the [new].
190
It defines the all calculation / aggregation with fact column name.
191
Here all calculation / aggregation are interdependent with the fields of fact column name, aggregator, data type and format of string.