Click here to Skip to main content
15,394,162 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to Search a Text into a Database objects Pin
$*Developer - Vaibhav*$16-Jun-14 20:41
Member$*Developer - Vaibhav*$16-Jun-14 20:41 
GeneralRe: How to Search a Text into a Database objects Pin
Ravindra Bisen16-Jun-14 20:43
MemberRavindra Bisen16-Jun-14 20:43 
GeneralRe: How to Search a Text into a Database objects Pin
$*Developer - Vaibhav*$16-Jun-14 20:45
Member$*Developer - Vaibhav*$16-Jun-14 20:45 
AnswerRe: How to Search a Text into a Database objects Pin
Ravindra Bisen16-Jun-14 21:07
MemberRavindra Bisen16-Jun-14 21:07 
AnswerRe: How to Search a Text into a Database objects Pin
Richard Deeming17-Jun-14 2:09
mveRichard Deeming17-Jun-14 2:09 
QuestionData Warehouse/SSAS Cube/Reporting and date assistance Pin
Member 1088784816-Jun-14 6:02
MemberMember 1088784816-Jun-14 6:02 
AnswerRe: Data Warehouse/SSAS Cube/Reporting and date assistance Pin
Mycroft Holmes16-Jun-14 12:49
professionalMycroft Holmes16-Jun-14 12:49 
GeneralRe: Data Warehouse/SSAS Cube/Reporting and date assistance Pin
Member 1088784816-Jun-14 22:41
MemberMember 1088784816-Jun-14 22:41 
Hi - thanks for your reply.
The fact table has a composite PK - FactDateID (the date of insertion) and DimRepairID (each repair is unique in the OLTP system). These combined will give a unique reference for a row.
My issue is how I solve the issue of displaying the correct data in a cube when I choose a date. For example:

RepairID 1 and date of 20140615 is inserted into the fact table. The financial value associated with this is 10. No new row is inserted for the 16th of June, as there was no activity on this repair. However on the 17th of June, the financial value was updated to 20 by a user in the OLTP system and therefore transferred to the DW. A new row of 20140617 with RepairID of 1 and value of 20 is then inserted.

Bearing in mind that there will be many RepairIDs in the fact table and some will have changed recently and others not, how do I enable users to pick a date and see what rows were what financial values at a given point in time?

Thanks
QuestionORM Rant Pin
Tomaž Štih16-Jun-14 0:55
MemberTomaž Štih16-Jun-14 0:55 
AnswerRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 3:37
mveRichard MacCutchan16-Jun-14 3:37 
GeneralRe: ORM Rant Pin
Tomaž Štih16-Jun-14 3:51
MemberTomaž Štih16-Jun-14 3:51 
GeneralRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 4:10
mveRichard MacCutchan16-Jun-14 4:10 
GeneralRe: ORM Rant Pin
Jörgen Andersson16-Jun-14 6:58
professionalJörgen Andersson16-Jun-14 6:58 
GeneralRe: ORM Rant Pin
Mycroft Holmes16-Jun-14 12:43
professionalMycroft Holmes16-Jun-14 12:43 
GeneralRe: ORM Rant Pin
Richard MacCutchan16-Jun-14 21:20
mveRichard MacCutchan16-Jun-14 21:20 
AnswerRe: ORM Rant Pin
Bernhard Hiller16-Jun-14 21:06
MemberBernhard Hiller16-Jun-14 21:06 
QuestionDistinct records on old school foxpro database file Pin
jkirkerx15-Jun-14 12:22
professionaljkirkerx15-Jun-14 12:22 
AnswerRe: Distinct records on old school foxpro database file Pin
GuyThiebaut15-Jun-14 22:03
professionalGuyThiebaut15-Jun-14 22:03 
GeneralRe: Distinct records on old school foxpro database file Pin
jkirkerx16-Jun-14 6:08
professionaljkirkerx16-Jun-14 6:08 
AnswerRe: Distinct records on old school foxpro database file Pin
Jörgen Andersson15-Jun-14 22:27
professionalJörgen Andersson15-Jun-14 22:27 
GeneralRe: Distinct records on old school foxpro database file Pin
jkirkerx16-Jun-14 6:11
professionaljkirkerx16-Jun-14 6:11 
AnswerRe: Distinct records on old school foxpro database file Pin
NitinDhapte16-Jun-14 23:30
MemberNitinDhapte16-Jun-14 23:30 
Answer[SOLVED], I finally go it Pin
jkirkerx19-Jun-14 18:42
professionaljkirkerx19-Jun-14 18:42 
QuestionUnable to establish a connection to sql database 2005 Pin
Otekpo Emmanuel14-Jun-14 11:57
MemberOtekpo Emmanuel14-Jun-14 11:57 
AnswerRe: Unable to establish a connection to sql database 2005 Pin
Kornfeld Eliyahu Peter14-Jun-14 19:22
professionalKornfeld Eliyahu Peter14-Jun-14 19:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.