Articles with this tag assume a beginner knowledge within this category.
Refining Cube Dimensions Once a cube has been created, dimensions should be refined by updating attributes and hierarchies. With respect to hierarchies, there are two primary types – natural and reporting. Natural Natural hierarchies contains relationships between levels and expand as they are traversed. One example of a natural hierarchy resides within the Geography dimension.…
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…
Please see my other MVC articles. Leveraging the MVC Grid to quickly display sortable, paging data. MVC provides robust data controls for displaying data sets. These grids come with many customizable features and require very little coding. To illustrate this feature, I’ll begin a Model for Sales Associates. Next, I’ll create a Controller which seeds…
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 