Traditional web-based reporting with SAS BI tools

Dynamic dimension with condition to another dimension

Reply
Contributor
Posts: 28

Dynamic dimension with condition to another dimension


Hi!

I have the following setup, cube -> infomap -> report.

The report should have the following look:

gruppbryt.png

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:

iif(

     [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? =)

BR

Daniel

Ask a Question
Discussion stats
  • 0 replies
  • 366 views
  • 0 likes
  • 1 in conversation