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…
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…
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…
Please see my other Database Development articles. Leveraging Format() for greater control over date values. When displaying date values from a resultset, it is common to reformat them according to various specified business rules. Using the t-sql Format along with specifying pattern provides an easy-to-use method, especially when abstracted into a reusable user-defined function.
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 