June 7, 2016 at 11:08 am
Hi,
I'm very new at SSAS. So I hope I am able to explain my problem with SSAS.
I have a table in SQL server with the following tables:
maintable:
SampleID (int) prim. key
Country (var)
Analyten (var)
ResultValue (int)
date (date)
...
analytentable:
ID (int) prim. key
Analyten (var)
UpperLimit (int)
In SSAS I imported the tables to use them as dimensions. I also have a timetable.
So now what I try to reach is, if the ResultValue from the maintable is higher than the UpperLimit in the analytentable, it should be displayed in Excel. If other "Analyten" are under the UpperLimit, they should be not displayed.
I don't know what is the best way to receive this goal. With MDX, Measures, ...? Have someone a solution for me?
Thanks in advance!!!
rb
June 13, 2016 at 4:39 am
rb76 (6/7/2016)
Hi,I'm very new at SSAS. So I hope I am able to explain my problem with SSAS.
I have a table in SQL server with the following tables:
maintable:
SampleID (int) prim. key
Country (var)
Analyten (var)
ResultValue (int)
date (date)
...
analytentable:
ID (int) prim. key
Analyten (var)
UpperLimit (int)
In SSAS I imported the tables to use them as dimensions. I also have a timetable.
So now what I try to reach is, if the ResultValue from the maintable is higher than the UpperLimit in the analytentable, it should be displayed in Excel. If other "Analyten" are under the UpperLimit, they should be not displayed.
I don't know what is the best way to receive this goal. With MDX, Measures, ...? Have someone a solution for me?
Thanks in advance!!!
rb
The simplest way would be to create 2 measure groups from the two tables and set them as hidden. Then create a calculated measure that uses a case statement that uses the logic you describe, with the values that fall into the latter bucket being set to NULL.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply