Showing posts with label Analysis Extensions. Show all posts
Showing posts with label Analysis Extensions. Show all posts

Tuesday, April 10, 2012

Steps To Update Time Dimension in OLAP

  1. Open SQL Server Business Intelligence Development Studio (this is on the start menu under Microsoft SQL Server 2005 and also referred to as BIDS).
Then you will want to select file – open then Analysis Services database. You want to specify the OLAP database.
  1. Once the database opens in solution explorer under dimensions find the time dimension. Right click on the time dimension and select open.
  2. With the time dimension open right click on time and select properties.
  3. In the properties for time in the source field see what value you have. If you have an end date of 12/30/2010 or something before that you should follow these steps.
Change the time dimension to have an end date at some point in the future. In my other case with this issue they set it to 12/31/2012 but you really could pick any time in the future (within reason). You would change this in the properties of the  time dimension. You would expand the source section and change the Calendar  End Date to some future date.
  1. Next we need to check what the time dimension is set to in Dynamics AX. To do this in Dynamics AX go to Administration > Setup > Business analysis > OLAP > Update BI project > Time Dimensions tab. If the end date is set to 2010 then change that to match the end date that you gave the time dimension. Then click ok on this form.
  2. Now you need to update the exchange rates in the BI-Exchange Rates table. To do this go to Administration > Setup > Business analysis > OLAP > Setup Exchange Rates. On this form pick the company that you want to use exchange rates for and click ok. This will create entries in the BI-Exchange rates.
  3. The final step is to go back to BIDS and process the OLAP database.

Friday, February 24, 2012

Analysis Extension Installation in Ax 2009 Troubleshooting

While Installing the Microsoft Dynamics Ax 2009 Analysis Extension the following error has been raised which is resolved with the following solution.

ssas-ax-02
After applying the KB article SSAS Extensions still will not install.  Further research seems to indicate that the problem might be with some 9.0 SSAS assemblies in the GAC.
Setup does not recognize that SQL Server 2008 Analysis Services is
installed If you have SQL Server 2008 Analysis Services installed and you are
installing the analysis extensions, you might receive an error that says you
must install SQL Server 2005 Analysis Services with Service Pack 2. This
error message indicates that there is an Analysis Services 2005 version of
the Microsoft.AnalysisServices.dll file in the Global Assembly Cache.
Microsoft Dynamics AX does not support running Analysis Services 2005 and
Analysis Services 2008 on the same computer. To resolve this issue, uninstall
the Microsoft.AnalysisServices.dll file that has a version number of 9.0 from
the Global Assembly Cache (typically located at C:\Windows\assembly).
Important: Be sure that you do not uninstall the
Microsoft.AnalysisServices.dll file that has a version number of 10.0
ssas-ax-01
I checked and sure enough there were.  So I looked and found SQL Server 2005 Express installed on the machine, not sure why.
Anyway, I uninstalled SQL Server 2005 Express and also the SQL Server 2005 Analysis Services ADOMD assemblies.
ssas-ax-03
I checked the GAC after uninstalling the 2005 components and I had a clean GAC, only 10.0 references.
ssas-ax-04
On to install again…and the Analysis Extensions can now be installed!

ssas-ax-05
Oh how beautiful it is:
ssas-ax-06