MSBI (SSIS/SSRS/SSAS) Online Training
Saturday, September 25, 2010
Wednesday, September 22, 2010
SSAS - Usage Of OLAP PivotTable Extensions && PT Power
Hi Guys,
If you want to verify the background MDX query while you are browsing the cube from Excel, i have a very simple solution for you.By using the above 2 Add-Ins, we can analyze the data and MDX funcitionality in easy manner.
This is the best way to resolve the issues on Multi dimensional data.
ThanksRavindra
Useful Links:
http://olappivottableextend.codeplex.com/
http://www.sqlserverpower.com/UtilityDetail/PTPower.aspx
If you want to verify the background MDX query while you are browsing the cube from Excel, i have a very simple solution for you.By using the above 2 Add-Ins, we can analyze the data and MDX funcitionality in easy manner.
This is the best way to resolve the issues on Multi dimensional data.
ThanksRavindra
Useful Links:
http://olappivottableextend.codeplex.com/
http://www.sqlserverpower.com/UtilityDetail/PTPower.aspx
Monday, September 13, 2010
Capacity Planning for the DW/BI Environment
Hi All-
Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process. These two functions, BI reporting and ETL, grow in volume and frequency as a data warehouse grows. Additionally, database administrator (DBA) tasks, such as backups and table reorganizations can cause additional data warehouse bottlenecks because ETL, BI reporting and DBA tasks contend for the same resources.
On top of that even we can maintain capacity of DW/BI environment by analyzing the below analytical approaches.
how many customers will be in the warehouse?,
at what rate will the customers grow?,
how many transactions will be in the warehouse?,
at what rate will the transactions grow?,
what other data will be in the warehouse?,
at what rate will the other data grow?,
what is the proper level of granularity for data in the warehouse?,
can the level of granularity be changed if needed?,
what amount of history is needed in the warehouse?,
will the user decide to add more history than anticipated?, and so forth.
See the below links for more info.
http://www.inmoncif.com/view/33
http://www.dmforum.org/portal/library/capacityplanningforthedwInmon.pdf
~Ravindra
Capacity planning is a problem for a data warehouse because it sets contrasting functional requirements against each other. On one hand, data warehouse customers consume data warehouse capacity as they query the data in the data warehouse business intelligence (BI) reporting. Meanwhile, applications consume data warehouse capacity as they load data into a data warehouse through the extract, transform and load (ETL) process. These two functions, BI reporting and ETL, grow in volume and frequency as a data warehouse grows. Additionally, database administrator (DBA) tasks, such as backups and table reorganizations can cause additional data warehouse bottlenecks because ETL, BI reporting and DBA tasks contend for the same resources.
On top of that even we can maintain capacity of DW/BI environment by analyzing the below analytical approaches.
how many customers will be in the warehouse?,
at what rate will the customers grow?,
how many transactions will be in the warehouse?,
at what rate will the transactions grow?,
what other data will be in the warehouse?,
at what rate will the other data grow?,
what is the proper level of granularity for data in the warehouse?,
can the level of granularity be changed if needed?,
what amount of history is needed in the warehouse?,
will the user decide to add more history than anticipated?, and so forth.
See the below links for more info.
http://www.inmoncif.com/view/33
http://www.dmforum.org/portal/library/capacityplanningforthedwInmon.pdf
~Ravindra
Subscribe to:
Posts (Atom)