Implementing a Cube Design Now that I’ve covered the basics of how to design a cube, I will demonstrate the basics of creating a cube. Within Solution Explorer, launch the New Cube Wizard. Proceed to the second step and select to Use existing tables and click Next. Select a measure group(s) which contain measures and dimensions…
Using BIDS to Explorer Cube Characteristics and Data With my cube designed and created, I will now leverage the BIDS interface to expose its rich features. First, I’ll select the Customer dimension to Explore Data. Now I’m presented with a series of sub-tabs which I may use to view Table data, use a Pivot Table, view…
Ensuring Rich Reports based on Cubes Often when beginning business intelligence development, specifically within data warehouses, a team may inefficiently “reinvent the wheel” rather than leverage existing reports and processes which may prove valuable to the organization. When cubes are designed, even new ones, the following steps will help to ensure the data they produce…
Using Excel to View Cubes and Configure Pivot Table Reports Similar to my article SSAS BIDS Cube Browser, Microsoft provides another tool for any end user to view a cube’s measures and dimensions to configure highly analytical reports. First, use the wizard under the Data tab to configure an connection to your cube. In the…
Using BIDS to Configure Cube Reporting Microsoft provides a cube browser within the Business Intelligence Development Studio (BIDS) which allows a developer to view cubes and construct reports using dimensions and measures. The functionality is similar to using Excel to view and configure cube reporting. For this article, I will use the sample data warehouse…
Arranging Database Tables to Support Rich, Effective Analysis In traditional systems used for e-commerce or other common input/edit systems commonly referred to as online transactional processing (OLTP), there should be no instances of duplicate data, for OLAP the opposite is true. For OLTP systems the focus is on the fastest method of providing high-volume additions…
Providing rich formatting within text. Most reports require some type of rich formatting usually reserved for HTML. However, SSRS provides such formatting utilizing expressions. Drag a textbox onto the Report Designer. Resize the textbox to fit. Here it is with some formatting. After setting the textbox expression to display the current date/time, my textbox looks…
Cognos Development Cognos: An Overview Cognos: Framework Manager Cognos: Report Studio – Objects Types Cognos: Report Studio – Creating a Report Cognos: Report Studio – Filters and Prompts Cognos: Framework Manager – Relations Cognos : FrameWork Manager – Models Cognos: Report Studio – Report Advancements
TechMbaBi 