Viewing 15 posts - 1,606 through 1,620 (of 11,676 total)
It is possible, but you need Power View for SharePoint.
Inside Excel, you need to pull the data from your cube into Power Pivot and then build your Power View report...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 5:36 am
The first one is clustered index, the second is a nonclustered index.
The difference is huge. A clustered index sorts the data according to its key, hence the clustered index IS...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 4:48 am
This is something that might take some planning.
How big is the table?
Is the column used in indexes or in constraints?
Be aware that changing the width of the column might update...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 3:46 am
Grant Fritchey (10/17/2014)
And might I add, it was odd seeing my name as a topic. Ha!
Who knew you'd get this popular? 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 3:41 am
GilaMonster (10/17/2014)
All posts have always had an edit button.The part where they're going to a broken site is new, they used to just reload the thread.
Ah ok, apparently I didn't...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 2:49 am
Try this:
=Globals!ReportName & " on " & Format(DATEADD(DAY,-1,NOW()),"dd MMM yyyy")
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 2:48 am
paul.knibbs (10/17/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 2:40 am
Nice one to end the week, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 17, 2014 at 12:29 am
Only allow the execution of stored procedures?
Even if there is a way to enforce a WHERE clause, you can still always write WHERE 1 = 1.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 8:20 am
Take a look at data driven subscriptions:
Create a Data-Driven Subscription
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 6:51 am
nostalgic.raj (10/16/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 5:21 am
BWFC (10/16/2014)
I'm not going to complain about missing points because guess what, I've got a point by posting this.
Woohoo! 😎
😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 1:42 am
You need to use expression on your flat file connection manager.
Dynamically set Flat File Connection Manager
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 1:38 am
anbu899 (10/16/2014)
i have all permission...
The error says otherwise...
Can you share the code?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 1:35 am
The error message seems quite clear: either you specified an incorrect connection string, or you (or the account executing the package) don't have the permissions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2014 at 1:22 am
Viewing 15 posts - 1,606 through 1,620 (of 11,676 total)