‘Training & Consulting in Crystal Reports’ Archives
How to categorize transnational data by phases if the information about phase is not stored in transactions table ?
How to aggregate transnational data by phases if the information about phase is not stored in transactions table. Recently I encountered a scenario where I have to aggregate the information about Account holders spending transnational history by different phases, let's say there were 3 phases in which these transactions were falling. Transaction [...]
This video explained very well the concepts of dimensional model.
In this post we are writing more on factt table in star schema because we believe that clear concept of fact table and its creation is critical to understand the difference between OLTP Relational Database’s logical model and then its de-normalization to create Star schema, which have fact table in the centre. We found some useful writings [...]
This present s an example showing the process to denormalization for dataware house or data mart Star schema. We researched on this topic in various books and even Microsoft examples they only give sample, but we think it is more important to know how oltp data model is converted in Star schema or olap. We used Microsoft’s Northwind data [...]
So far we have tried many dynmic web softwares which are also known Content Management System. They run on top of database or inother words all the information is saved in database. we used ASP classic and SQL Server 2000 database and had our hand wet with vb scripting, it was in the late 90s and early 2000. then microsoft used asp.net. Then we [...]
We would like to share our experiance of using Laptops from Gatway, HP and Toshiba. As a database and BI consultant Laptop is like my tool to write, present and design just like a pen is to an author. Over the years of experiance in using laptops for my professional career I found Gateway the best, whereas HP and Toshiba I would sad to say Sucks. [...]
I recently faced this issue which deploying a Sql Server Analysis Project 2008, however was able to resolve by doing the following; I did, go to services, change the SSAS service to use the local / admin account. this error will then vanish.
Quality Control - (a) Planned systematic activities necessary to ensure that media conforms to established technical requirements. (b) All actions that are taken to ensure development of products that meet performance requirements and adhere to standards and procedures. (c) Policy, procedures and systematic actions established in an enterprise for [...]
This post ic about Data quality which always done in every organization it is presented here in more formal words: Primary goal of a data integration solution is to assemble data from one or more data sources. As you bring data together, you are likely to find a broad range of data quality issues that require attention. For example, you may [...]