The ForeignKeyName attribtute of a relationship is greyed and empty when I edit a relationship of a data source view in SQL Server 2008 BIDS. How can I edit it?
View Complete Post
Scenario: Bank Accounts and Customers. One Account can have many customers and many customers can have one joint Account. so its Many to Many relationship.
Special Scenaio: Bank provide us daily snapshot of all thier dimensions and facts, every night thier ETL run, and newsnapshot is available, previous is gone.
I am using SCD Transformation to update the dimensions, Type 1 for all the columns.
Tables1: DimAccounts (AccountsID(PK))
Table3:DimBridge (AccountID (FK), CustomerID(FK), RelationShip (varchar10))
Question1: Are we supposed to treat bridge tables as Dimensions or Facts?
Question2:If it is to be treated as Dimension, How would I apply SCD Wizard to it, Since there are two business keys involved?
Question3: Do i need surrogate key in Bridge Table, like i have in other dimensions?
I have one dimension table with over 600 item, but in my fact table only 40 of this member have lines (my fact have a filter for the 2 laste year)
How save on the dimension only this 40 members?
How do I need to handle a case in which the fields in a fact table that represent the foreign keys to the dimension tables might change? What kind of process do I have to do to the cube?
This is quite difficult for me to communicate so please bear with me.
I have created my data source view in my solution. I have a central fact table surrounded by the dimensions. Several of the dimensions have dates which I converted to integers. Thinking that I would need separate date dimension tables so the date integers
could find their dates I created a data dimension table "snowflaked" to the dimensions with dates.
An example is my dimPolicy table has dates of creation and ending.
I converted these to integers.
A table called dimPolicycalendar was made in the DSV and then linked. A dimension snowflaked to a dimension.
When I went to create a dimension for Policy it auto attached the dimPolicyCalendar. Then all my dates disappeared. And the generic values in the dimPolicyCalendar appeared.
HELP HELP HELP PLEASE!!!
How do I get my values back?
If I wasn't supposed to add a calendar table to the dimension how will I convert those integer values to the date values I want?
I am panicking a little because I can not find any helpful resources.
You are my last hope before we are pushed to an Oracle solution. Yuck!
I've read several articles about SCD, most of them exmplaining the standard SCD type 2 rules, like a customer adress change.
My problem is about PurchaseOrders changes :
I have a fact table "Internet Sales", with a Total property for each sale
Imagine that this Total property can change (ie. : missing product cannot be delivered) --> the order is recalculated, and its total changes. Of course, I need to keep both informations for the order, because if I do a request for the sum of the order
totals for example, I won't get the same results if the request is done with data as they where BEFORE or AFTER the Total change. .... hope that's clear.
I wanted to add a "start", "end" and 'current" columns on my fact table, but I read that it's not the good way to do.
Can you help me with that ?
PS : I didn't consider the option of setting the order total in a dimension.... hope that's not the good way to do !
I have one fact table that contains all the measures. The problem is that I want to have two measure groups that point to this one fact table. Some measures would be in measure group A and some in measure group B but the underlying
source still comes from the one fact table. I haven't found a way to do this.
My solution currently is I have created another fact table that is an exact copy of the main one, that way I can create two measure groups. The issue is performance, it takes 4 minutes to build and if I took one of those fact tables out it would be
cut in half.
I would have thought there would be a way to create a measure group and drag what you want in there..but it seems that this isn't the case that you can only create measure groups based on how many fact tables you have.
Any help would be appreciated.
If I have a fact table with a geography dimension where zip code is the primary key in the dimension table and the foreign key in the fact table, is there a way to create a cube where the leaf level in the geography dimension is at a higher level, say City
(or State), even if City (or State) is not an attribute on the fact table?
Alternately, if I have a fact table with dates but I only want monthly summary data in my SSAS cube, is there a way to make the Month level the leaf level member of the Time dimension in the cube without adding a Month foreign key column to the fact table?
It would seem to me that people would want to do this wiht some frequency; however, I can't find a way to do it in the SSAS documentation. This link seems to suggest that the grain of the cube has to be basically the same as the grain of the fact table
in all cases: http://msdn.microsoft.com/en-us/library/ms166573.aspx