PugMaster at 09h10
10
Sep
2010
Surrogate Key causing incorrect results
Hi
Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:-
I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications submission over time, but because the business key may appear more than once (a new row is inserted when the application status changes, and the Surrogate key is the logic
Hi
Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:-
I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications submission over time, but because the business key may appear more than once (a new row is inserted when the application status changes, and the Surrogate key is the logic
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
CBI has still not updated the auction results since Sunday. As of 2:30 Baghdad time, Answar al Iraq had no released an auction results on its website either.
can you tell me if there are any disadvantages of using a surrogate key in the enterprise data warehouse ?
Forum URL - http:www.b4tr.forumotion.net
Forum Name - Country of The Rain
Problem - Old Forum Name (Black Thunder) Displayed in Browser Tab
How can I fix this?
(Modified Screenshot Below, I apologize for poor quality and size)
OK, so how about when people are signing up, instead of forgetting that your password is short or your password isn't strong etc..
it should have Javascript and appear like this. It would say:
Think about it, it will be more helpful of reminding
Forums from same category
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
LEGO Island Discussion, modding, news and more!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Search
Informations
4 Replies For the topic :
"Surrogate Key causing incorrect results"
This topic has been viewed 1737 times.
Last message :
10/09/2010 at 09h10 by "PugMaster"






