Microsoft Analysis Services - Source [Wikipedia]

Microsoft Analysis Services is part of Microsoft SQL Server, a database management system. Microsoft has included a number of services in SQL Server related to Business Intelligence and Data Warehousing. These services include Integration Services and Analysis Services. Analysis Services includes a group of OLAP and Data Mining capabilities.

History

In 1996, Microsoft began its foray into the OLAP Server business by acquiring the OLAP software technology from Israeli-based Panorama Software. Just over two years later, in 1998, Microsoft released OLAP Services as part of SQL Server 7. OLAP Services supported MOLAP, ROLAP, and HOLAP architectures, and it used OLEDB for OLAP as the client access API and MDX as a query language. It could work in client-server mode or offline mode with local cube files.

In 2000, Microsoft released Analysis Services 2000. The rename from OLAP Services happened because the inclusion of Data Mining services broadened the scope of the product from just OLAP. Analysis Services 2000 was considered an evolutionary release, since it was built on the same architecture as OLAP Services and therefore backward compatible with it. Some of the major improvements included more flexibility in dimension design through support of parent child dimensions, changing dimensions, and virtual dimensions. Another major area of improvement was a greatly enhanced calculation engine with support for unary operators, custom rollups, and cell calculations. Other new features were dimension security, distinct count, connectivity over HTTP, session cubes, grouping levels, and many others.

In 2005, Microsoft released the next generation of OLAP and Data Mining technology as Analysis Services 2005. It maintained backward compatibility on the API level: although applications written with OLE DB for OLAP and MDX continue to work, the architecture of the product was completely different. The major change came to the model in the form of UDM - Unified Dimensional Model.

Timeline

The key events in the history of Microsoft Analysis Services cover a period starting in 1996.

Microsoft Analysis Services Events

• 1996-07-01 - Microsoft opens new team to build an OLAP product, codenamed Plato (permutation of letters from OLAP)
  
• 1996-07-15 - Panorama Software delegation meets with Microsoft
  
• 1996-10-27 - Microsoft announces acquisition of Panorama Software development team
  
• 1998-11 - OLAP Services 7.0 (codename Sphinx) ships
  
• 2000-08 - Analysis Services 2000 (codename Shiloh) ships
  
• 2001-11 - XML for Analysis SDK 1.0 ships
  
• 2003-04 - ADOMD.NET and XML for Analysis SDK 1.1 ship
  
• 2005-10-28 - Analysis Services 2005 (codename Yukon) ships
  
• 2008-08-06 - Analysis Services 2008 (codename Katmai) ships
  

Storage Modes

Microsoft Analysis Services takes a neutral position in the MOLAP vs. ROLAP arguments among OLAP products. It allows all the flavors of MOLAP, ROLAP and HOLAP to be used within the same model.

Partition Storage Modes

• MOLAP - Multidimensional OLAP - Both fact data and aggregations are processed, stored, and indexed using a special format optimized for multidimensional data.
  
• ROLAP - Relational OLAP - Both fact data and aggregations remain in the relational data source, eliminating the need for special processing.
  
• HOLAP - Hybrid OLAP - This mode uses the relational data source to store the fact data, but pre-processes aggregations and indexes, storing these in a special format, optimized for multidimensional data.
  

Dimension Storage Modes

• MOLAP - dimension attributes and hierarchies are processed and stored in the special format
  
• ROLAP - dimension attributes are not processed and remain in the relational data source. Partitions dimensioned by ROLAP dimensions must be in the ROLAP mode as well.
  

APIs and Object Models

Microsoft Analysis Services supports different sets of APIs and object models for different operations and in different programming environments

Querying

• XML for Analysis - The lowest level API. It can be used from any platform and in any language which support HTTP and XML
  
• OLE DB for OLAP - Extension of OLEDB. COM based and suitable for C/C++ programs on Windows platform.
  
• ADOMD - Extension of ADO. COM Automation based and suitable for VB programs on Windows platform.
  
• ADOMD.NET - Extension of ADO.NET. .NET based and suitable for managed code programs on CLR platforms.
  

Administration and Management

• DSO - For AS 2000. COM Automation based and suitable for VB programs on Windows platform.
  
• AMO - For AS 2005. .NET based and suitable for managed code programs on CLR platforms.
  

Query Languages

Microsoft Analysis Services supports the following query languages

1. Data Definition Language (DDL)
   
2. DDL in Analysis Services is XML based and supports commands such as <Create>, <Alter>, <Delete>, <Process> etc. For Data Mining models import and export, it also supports PMML.
   
3. Data Manipulation Language (DML)
   

• MDX - for querying OLAP cubes
  
• SQL - small subset of SQL for querying OLAP cubes and dimensions as if they were tables
  

DMX - for querying Data Mining models

How to Enable FILESTREAM Feature on SQL Server 2008

FILESTREAM is a new feature of SQL Server 2008 that supports BLOB [Binary Large Objects] file storage on NTFS file shares managed by SQL Server. The FILESTREAM feature is disabled during the default SQL Server 2008 installation.

To enable FILESTREAM feature on SQL Server 2008,

1. Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)
   
2. Navigate to the SQL Server Services node and select the SQL Server instance you want to modify SQL Server (MSSQLSERVER)
   
3. Click the FILESTREAM tab and select the checkboxes to enable FILESTREAM and enter a share name for the files, as shown

Rectify MOSS Setup error:

Setup is unable to proceed due to the following error(s): This product requires ASP.NET v2.0 to be set to 'Allow' in the list of Internet Information Services (IIS) Web Server Extensions. If it is not available in the list, reinstall ASP.Net v2.0.

Correct the issue(s) listed above and re-run setup.

Steps,

1. Run aspnet_regiis -i at .NET 2.0 folder. - [C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\]

2. If the error still exist, you need to manual "Allow" the asp.net 2.0 in IIS Web Server Extensions.

SL Economy Booming - Source [Bloomberg]

Sri Lanka May Sell Rupee as Post-War Inflows Increase

Sri Lanka may sell its currency should it gain too much as foreign aid and investments flow into the country after the end of a 26-year civil war, central bank governor Nivard Cabraal said.

"The currency could appreciate when large amounts of money come in," Cabraal said in an interview in Colombo yesterday. "But we learnt some good lessons in 2005 post-tsunami that we shouldn't allow these conditions to drive the economy by itself and there has to be some kind of intervention."

Cabraal said excessive gains in the rupee could damage exports, which make up a third of the $32 billion economy and employ more than 2 million people in the island's tea plantations and textile factories. Millions of dollars of aid after a tsunami hit Sri Lanka on Dec. 26, 2004, increased demand for the rupee, strengthening the currency by 5.4 percent the following month and halving export growth from a year earlier.

"The near-term pressure appears to be toward appreciation of the rupee," said Anushka Shah, an economist at Citigroup Plc. in Mumbai. Buying dollars will also help "build foreign- exchange reserves."

The Lankan rupee has gained 2.5 percent to 114.85 against the U.S. dollar since May 16, when President Mahinda Rajapaksa declared victory over the Liberation Tigers of Tamil Eelam, who have been fighting for a separate homeland for ethnic Tamils since 1983.

Very Comforting

Sri Lanka's benchmark stock index, the Colombo All-Share Index, has climbed 16 percent since the Tamil Tigers were defeated, taking its gains this year to 47 percent. The index rose 0.6 percent to 2,197.73 at 11:15 a.m. local time, paced by John Keells Holdings Plc., which has investments ranging from transportation to tea and tourism. John Keells has increased 41 percent since May 16.

Cabraal said foreign-exchange reserves increased by about $120 million in the past two weeks as overseas investors snapped up local shares on optimism of political stability returning to the Indian Ocean island nation.
"That has been very comforting to the foreign exchange situation," Cabraal said.

The nation's reserves more than halved in the six months from September to $1.4 billion as the global recession hurt export earnings, prompting Sri Lanka to start talks with the International Monetary Fund in March for a $1.9 billion bailout.

IMF Loan

Sri Lanka's overseas sales dropped 7.8 percent in March from a year earlier, falling for the fourth straight month. That's the longest period of declines since 2002.

Standard & Poor's said May 21 the timing and implementation of the IMF loan was "uncertain" and cut the island's rating outlook to negative from stable. S&P rates the nation's long- term foreign currency debt at 'B', five levels below the investment grade.

The IMF on May 21 said it is near an agreement to lend the money to Sri Lanka, clarifying its position a week after U.S. Secretary of State Hillary Clinton said the U.S. was reluctant to support an IMF loan to Sri Lanka given the escalation in the country's civil war.

"The IMF loan has been delayed because some countries have expressed concerns which are of a non-economic nature," Cabraal said. "The IMF charter doesn't allow for such issues to be raised in the provision of structural loans - this will set a bad precedent."

Civil War

Now that the war is over, foreign direct investments into Sri Lanka could quadruple to as much as $4 billion a year by 2012, according to Dhammika Perera, chairman of the Board of Investment of Sri Lanka.

The last time Sri Lanka faced a huge inflow of foreign cash was when the tsunami struck the nation and killed more than 30,000 people.

The challenges the inflows may pose this time include higher inflationary pressures, Cabraal said.
"For the moment, inflation is benign and we expect it to touch zero percent by June," Cabraal said, adding that such a scenario would give him room to keep interest rates low and support economic expansion. He said the 3.3 percent increase in consumer prices in May from a year earlier, after a 2.9 percent gain in April, was a "blip."

Cabraal said the central bank will this month revise the nation's growth forecast for 2009, and may almost double it to 5 percent because of the increase in business confidence and as the liberation of rebel-occupied land boosts farm production.

"For a long time, every time someone spoke about Sri Lanka's economy, the response was if only not for this war," Cabraal said. "Today that has been removed and we have a tremendous new scope for economic development."

Hope......

Maybe the darkness inside me....
Can never be lightened...
Everything seem to take a long period..
even with hopes...
Thing doesn’t seem to changed much...
but I never stop believing..
That no matter how dark it may be...
no matter how cruel reality is..
I will always.. hope for miracle to happened

Rumblings from the Battlefield

It affected us finally – Source [ AP ]

Global recession hits Lanka: Companies cut workforce

Global recession which had taken a stranglehold on the world economy has spread its tentacles in Sri Lanka too forcing 16 leading business ventures to lay off their entire workforce while 29 companies have retrenched part of the staff, Inter Company Employees Union said.

Among the companies which had laid off their entire work force are several garment factories and manufacturers of aluminum products and tiles. Companies located in remote areas such as Anuradhapura had also been forced to close down because of the global economic downturn

Some manufacturers of apparels, cement, cloth, plywood and bags have reduced their workforce while the others have warned of possible retrenchment after the Sinhala-Hindu New Year in April.

ICEU President Wasantha Samarasinghe, a former JVP parliamentarian told Daily Mirror the export volumes of some companies had dwindled by 80 per cent, and as a result were compelled to suspend their business operations.

Mr. Samarasinghe said his union identified the business ventures which stopped the overtime work of their employees or sent them home on compulsory leave following the financial crisis.

He said a leading cement manufacturer had curtailed its production by 40 per cent while the export earnings of a ceramic product manufacturing plant had come down by 30 per cent.

The International Labor Organization has predicted that more than 50 million workers will lose their jobs worldwide due to the recession. In Sri Lanka, 50,000 private sector employees are expected to lose jobs this year. Sadly though, the government has not worked out any plan to ensure the welfare of those who may be pushed to the streets, he said.

Mr. Samarasinghe said that though a Compensation Formula was introduced, there was no fund to compensate those losing employment in the present circumstances.

We are proposing the establishment of a safety net for these people. If this down trend continues, the government will also lose its revenue in terms of taxes levied on exports and imports, he said.

UNP parliamentarian Kabir Hashim said the absence of a proper macro-economic policy had resulted in the present economic crisis effecting Sri Lanka.

Mr. Hashim said inflation had increased because of the government had printed money despite the warnings by opposition parties, and this had resulted in increasing interest rates leaving businessmen in the lurch.

Today, our garment manufacturers have to obtain loans at an interest rate of 12 or 13 per cent. However, it is only two or three percent in countries such as Vietnam and India. So, some of our leading manufacturers have started factories in those countries while closing down their plants here, Mr. Samarasinghe said.

However, Consumer Affairs Minister Bandula Gunawardane admitted that Sri Lanka had begun to feel the pinch of the global recession, and it was beyond the government s control.

In the United States, 2.6 million people have lost their employment. A similar situation prevails in countries such as Singapore, Britain and Dubai. We have not felt the crisis to that extent, he said.

Rubber exports contribute only 1.8 per cent to the economy. From tea, we get around 16 per cent. There is a notable impact on the garment industry. The Board of Investment has made arrangements to provide employment to those losing jobs in other industries. There will be no problem for skilled workers, he said.

Minister Gunawardena said the Labor Ministry had worked out a programme to train the unskilled workers so that they could be absorbed into areas where job security prevails.

When asked whether the government would be able to guarantee an income to all workers losing their jobs, the Minister said no government in the world could do it.

Good Article about our Economy – Source [Asian Tribune]

How the Global Economic Crisis Affects Sri Lanka.

We too have now begun to feel the heat of ill-effects of the world economic recession despite various optimistic statements made by politicians and the top brass at high echelons in the government. Hundreds of private sector establishments in a number of fields have been shut down and employees are facing challenges they never ever thought could be realities.

Even BOI companies with foreign investments are steering in the direction of scaling down operations and retrenching employees. Naturally and obviously, when the country after country even in the highly developed world have begun to feel the heat of the global meltdown at their doorway, an already ailing economy like ours cannot conceal from the after effects of the chaos in the global financial markets.

At a time when the whole world is tumbling in an ocean of economic recession and financial catastrophe there is no chance of survival for a smaller economy like ours. Of course the only possibility is that a direct impact of the global situation might not affect us straight away, but yet it's off spins might create a significant brunt. However, such off spins could be quite capable of totally devastating a diminutive economy like ours if the issues are not addressed in the right perspective at the right time.

Around one million expatriate workers distended all over the world mainly in the Middle East, remit increasing amounts of Dollars to inject strength into our ailing economy. This top foreign exchange earner of our country is facing the risk of slamming the brakes on worker remittances as a result of the global financial crisis which would rigorously intensify our economic wretchedness.

Moreover, apart from the uncertain labor market, we have reached the brink of falling world prices and demand on our main exports. Tea, rubber, cinnamon, coconut, garments, gems and a number of other commodities have faced the quandary of loosing demand in the international market thus experiencing sharp falls in prices as well as demand. Gem and jewelry industry can no longer attract overseas buyers for some time. Tourism is operating at grave losses.

Also we do not possess adequate foreign assets to brag. Of course extension of GSP+ concession to the garment exporters by a couple of years has given some sigh of relief to that industry. Nevertheless, with the added effect of synthetically held local currency, the situation has dramatically worsened. Needless to say that by artificially holding the local currency in order to lower import costs doesn't at all compensate for the losses the economy suffers through reduced export income.

Strongest economy on earth with ubiquitous assets and gigantic martial command escorting the economic, political, intellectual and military supremacy over all other nations is where the tribulation set in motion. Financial, trading, service and production sectors in the US market are in ruins; banking institutions, investment companies, insurance and other asset management companies have crashed. Even Europe, Japan and Australia are going through the same fate.

At the rate the financial crisis is swallowing up the world in full bloom and the credit crunch is munching the global markets in style, frail economies such as ours have no chance of standing alone. Most disturbing question is how long can we stand this situation? With all the efforts the world high powers are putting in, recuperation of the global trade and industry is at least a couple of years away. When the global financial crisis hit on the head, our economy was already burning in turmoil.

War, inefficiency, bribery, corruption , extortion, fraud, nepotism, cronyism, terrorism, frittering away public funds by the politicians and high ranking public servants, high energy costs, high inflation, uncontainable exchange rates, attitude problems are some of the factors that made things worse for our country. However, though the recent global crunch only added just one more factor to the hit list, the blow it can turn about could be severe due to its rapid and swift augmentation throughout. In every probability, there is no way Sri Lanka can keep away from the effects of economic recession but certainly the authorities could think and act sensibly towards finding ways of minimizing the impact by adopting proper policies. Most of all, the important thing is to adopt proactive policies.

It is a film that is extremely close to my heart.

John Q is a 2002 film starring Denzel Washington as John Quincy Archibald, a father and husband whose son is diagnosed with an enlarged heart and then finds out he cannot receive a transplant because HMO insurance will not cover it. Therefore, he decides to take a hospital full of patients hostage until the hospital puts his son's name on the donor's list. The film was directed by Nick Cassavetes.

John Q is a protest against the policies and hidden procedures of many insurance companies at that time. The film also stars Kimberly Elise, Anne Heche, James Woods, Ray Liotta, Eddie Griffin and Robert Duvall, among others.