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 |
|
gunja_22
Starting Member
4 Posts |
 Posted - 2007-12-25 : 13:38:13
|
| how to create a role playing dimension in SSAS. Like If I have a period dimension table with a key named as per_key and fact table which has keys named as from_per_key and to_per_key .Now both the fact table keys need to be connected to the Period dimension per_key.gunja |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-25 : 23:29:21
|
| [url]http://msdn2.microsoft.com/en-us/library/ms174487.aspx[/url] |
 |
|
|
gunja_22
Starting Member
4 Posts |
Posted - 2007-12-27 : 09:00:23
|
| Hi , after using role play dimension wen im deploying the cube .. im getting this eror:Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Fact_CSS, Column: fc_css_per_applied_from_key, Value: 1/1/2006. Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: per_key of Dimension: Period_from key from Database: test, Cube: Customer Satisfaction, Measure Group: Customer Satisfaction Survey, Partition: Customer Satisfaction Survey, Record: 1.Please suggest some solution .gunja |
|
|
|
gunja_22
Starting Member
4 Posts |
Posted - 2008-01-03 : 23:59:53
|
| i got it.gunja |
|
|
|
|
|
|
CREATING ROLE-PLAYING DIMENSION