09-11-2013 07:55 AM
I have the following setup, cube -> infomap -> report.
The report should have the following look:
So far so good. Now the issue is that for year 2005 I want to show all the ages (år) for people, but for 2004 I want only to see 1år-3år. Year and age are two different dimensions, is it possible to add a filter (in cube or infomap) which basicly say that if year > 2004, show all ages, else only show ages 1år-3år?
I've tried to add a calculated member in the cube but the dimension does not show in infomap studio, adding a olap-member directly in the infomap generates an error. The code I've tried just to test the possibility of creating a "dynamic dimension" is something like the following:
[Födelseår].[Födelseår].level.name = "2005",
[Uppnådd ålder].[All Uppnådd ålder].[6 år],
[Uppnådd ålder].[All Uppnådd ålder]
Does the great minds in this forum have any suggestions? =)