Forum Replies Created
Viewing 15 posts - 2,581 through 2,595 (of 11,676 total)
-
RE: 2008r2 Cube not linking two views on key
Ryan1 (6/17/2014)
The measure group is made from the view which does not contain any of these dimensions, therefore there is no key which matches the 'Measure Group Column'.Can you give...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: Migrating sql 2005 to 2012 SSIS, SSAS, SSRS
SQLTougherGuy (6/17/2014)
Thanks very much. That really helps in my analysis. I always say that unless your really need the new "bells and whistles" of 2012, I don't see the point...Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: Are the posted questions getting worse?
Kaput?
Oh Steve, why have thou forsaken us?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: how to load multiple flat file
vignesh.ms (6/14/2014)
how to load all files in a directory in ssis with different delimiter ?I have tried this using Foreach File Enumerator. It works fine for same delimiters, but I...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: Migrating sql 2005 to 2012 SSIS, SSAS, SSRS
There are quite some differences between 2005 and 2012, in all three of them.
SSAS will be OK for most parts. SSRS might be more difficult, as 2012 uses the more...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: Error: The Project could not be deployed to 'localhost'
hoseam (6/17/2014)
I need to Use SSAS, I want to learn about Cubes and all of that, the SSAS part of BI. It's for learning purpose nothing more.If money is an...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: 2008r2 Cube not linking two views on key
Ryan1 (6/17/2014)
Attached is what my dimension usage tab looks like.Gender, Automobile, and Customer is from view one which contains only data that is directly linked to dimensions.
Dates is a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: CTE Incorrect Syntax
Sean Lange (6/17/2014)
You could make this a lot simpler and skip the cte entirely.SELECT @Total = count(CAST(id AS VARCHAR(60))) FROM cat_transaction
EXCEPT
SELECT ext_reference FROM Patricia.dbo.BUDGET_LINE
I beg to differ:
SELECT ID...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: Are the posted questions getting worse?
Luis Cazares (6/17/2014)
I'm not sure what happened in here :w00t:Inception!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: error while installing sql server database engine
EdVassie (6/17/2014)
The SQL Server install will fail if both the account running the install and domain name are the same.Create a different account on your machine and rerun the install...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: Interesting issue with an Agent job suddenly taking longer...
Maybe your production database got slower 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: How does rollback work after log file ran out of space?
Since transaction are atomic, you cannot resume them somewhere in the middle. Either it finished, or it rolled back and "never happened".
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: CTE Incorrect Syntax
crazy_new (6/17/2014)
Thanks Koen,Got it working.
Really appreciate your help man.
No problem, it is my pleasure. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: CTE Incorrect Syntax
Do it like this:
WITH CTE_Test (ID)
AS
(
SELECT CAST(id AS VARCHAR(60)) FROM cat_transaction
EXCEPT
SELECT ext_reference FROM Patricia.dbo.BUDGET_LINE
)
SELECT @Total = COUNT(ID)
FROM
CTE_Test;
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
RE: Installing Reporting Services on existong server
If someone at the company has an MSDN subscription, you can download the SQL Server installation media.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 2,581 through 2,595 (of 11,676 total)