Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
 sannidhikumar
		
			sannidhikumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi All ,
after removing synthetic keys the data is not matching properly .
any suggestions ,
thanks ,
 
					
				
		
 m_woolf
		
			m_woolf
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Would have to see the data and the data model to comment.
 jonas_rezende
		
			jonas_rezende
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi, pradeep kumar.
Please, share qvw with us.
Regards,
Jonas Melo.
 
					
				
		
 sannidhikumar
		
			sannidhikumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 aapurva09
		
			aapurva09
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
You need to make sure the right keys are used for connection. Here in the screenshot it can be seen there are date related fields that are common. If you want your connection to include the date fields, they should be added in your 'Key' field.
Thanks
 
					
				
		
 sannidhikumar
		
			sannidhikumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Apurva ,
i already concatenated but the data is getting wrong any other solutions .
thanks ,
 aapurva09
		
			aapurva09
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you share how you concatenated the fields to make 'Key' field?
 
					
				
		
 sannidhikumar
		
			sannidhikumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		after concatenated i got this result .
 
					
				
		
 sannidhikumar
		
			sannidhikumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Apurva ,
i used concatenate fact table then at last i got this result . you can check the above synthetic keys Data Module.
thanks ,
 
					
				
		
 sannidhikumar
		
			sannidhikumar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		hi All ,
any one there to reply to this query .
thanks ,
