I am trying to create a functionality that allows the user to change on
automatic mode the monetary values showed into the report, according
to a factor that represents the economic inflation of the country
since 3 years ago. Even In that cube I need to store some other
economic indicators, as the inflation of other countries, change types,
etc.

I have problems with the integration of that cube with all the others
on the Datamart, because I'm trying to create virtual cubes with all
the physical cubes, the problem is because the indicators cube has only
TIME dimension and if I try to see some information by other dimension
from the virtual cube, OLAP shows that no Information are available.

Someone knows how to solve this ? Maybe I am trying on the wrong way
....

Thanks in advance.

Shouldn't you also have Country dimension beside the Time dimension in the
Indicator cube ? Anyway, in the formulas, instead of using Inflation
measure, you can use ValidMeasure(Inflation), which will propogate inflation
rate to the dimensions other then Time.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

<omar.obando (AT) gmail (DOT) com> wrote