Search code examples
iccube

IcCube - refresh schema without reloading of data

In the default perspective of my cube I renamed the dimension, hide one, and changed default member. For example something like this:

default [Geography].[Geo].[City].[Madrid]
-[Time]
rename [Geography].[Geo] as [Location]

If I want to see the changes in the Excel Pivot Table I need to redeploy and reload the schema, but as I understand while loading schema, data from underlying tables are also reloaded. Is it possible to avoid reloading of data, and at the same time to see this changes in the cube?

Solution

  • Perspectives cannot be defined dynamically so you'll have to reload the schema.

    Nevertheless, you could setup an offline snapshost (www) to be able to reload faster your schema.

    Hope that helps.