Our mantra here at Solver is “make it simple, sexy and powerful”. Traditionally, Data Warehouse projects are reserved for the IT folks in an organization, but we have set out to change that notion with the BI360 Data Warehouse.
We are busy working on many new and exciting features for the upcoming version of the BI360 suite. Here is a quick sampling of two items in the cooker: 1) Adding Attributes and 2) Time Dimension.
Adding Attributes in a Snap
It is a common practice to want many attributes for each dimension. In the current BI360 Data Warehouse (BI360 DW) version, dimension attributes can be added using the Data Warehouse Manager user interface or they can be configured through SQL Server. We have now also added a dimension and attribute import wizard In order to accelerate the time to design and deploy to the warehouse. The wizard automates the process of creating a large number of dimensions and related attributes. Simply create the dimensions and/or attributes in an Excel or text file and import using the Warehouse Manager.
Once the new dimensions and/or attributes are loaded, then they are immediately available to be managed within the Warehouse Manager as well as the Reporting, Planning and Dashboard Modules.
Take Control of your Time Dimension
Configuring the time dimension has always been quick and easy and met most requirements out of the box. However, we decided to take it to the next level and add controls to define the date ranges within each period from the Warehouse Manager. Now, configurations such as 4-4-5, 5-5-4, 4-5-4 or any other fiscal configuration, then the BI360 Warehouse Manager can easy implement it.