Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2010-04-15 : 13:26:59
|
| I have a cube deployed to a Standard Edition of SSAS 2008. I'm trying to create a URL action based on the current members of the selected cells. The problem is that when I build the URL I want the Key of a dimension that is not part of the query that got me to the results. It's also the foreign key in the fact table(Claim number). Since I'm not using Enterprise Edition I can't make an account measure or a non aggregated measure. This would make it easy.So how to I reference the key for DimAccount when I'm not getting to the underlying cells using that dimension? when I use + [DimClaim Detail].[Dim Claim ID].Currentmember.Value I get nothingI can include that data into a drill through with no problem. But this solution eludes me.Any ideas?An infinite universe is the ultimate cartesian product. |
|
|
|
|
|
Trouble with URL action