Viewing 15 posts - 841 through 855 (of 11,676 total)
Why don't you join directly in the source component?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 30, 2015 at 2:06 am
What if you go to the empty column on the right and start typing a formula there?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 30, 2015 at 2:05 am
This measure that counts all rows, what does it count exactly?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 30, 2015 at 2:04 am
Right-click on the field, click Expression.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 26, 2015 at 4:36 am
WayneS (3/25/2015)
Jack Corbett (3/25/2015)
GilaMonster (3/25/2015)
spaghettidba (3/25/2015)
The accusation "man = male chauvinist" is very common, that's why everybody wants to say they're not like that.
Annoyingly so, along with the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 26, 2015 at 2:16 am
I did some research, but I can't currently find a way to show the ALL member in a slicer.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 1:21 pm
Please post table DDL and sample data in the form of INSERT statements next time.
It helps the people to help you, and you don't have to wait too long for...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 9:15 am
You can check if the first parameter is empty. If it is, only use the second parameter. If it isn't, concatenate both.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 7:30 am
How exactly did you put those fields in the tablix? Did you use an expression?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 7:13 am
Sushant Yadav (3/25/2015)
Yes the preview of the query is showing 0 as output.but when I tried the same using Microsoft OLEDB provider for Oracle it giving me proper out-put
Did you...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 7:07 am
coetzeehuman (3/25/2015)
I found the underlying problem.
I have a loop checking a remote server, and picking up the files from there, this is where the problem lies. The executing user...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 6:28 am
Sushant Yadav (3/25/2015)
I have used OLEDB source in data flow and then written query with where clause to select data from oracle.
Does the preview return 0 rows as well?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 6:27 am
coetzeehuman (3/25/2015)
Hi KoenI used a Flat File source component.
Thank you for your reply
And I guess you used a flat file connection manager?
Strange.
What happens if you rebuild the data flow from...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 6:00 am
Jonathan Mallia (3/25/2015)
Hi Koen,Yes, but is it possible to have All Products as another member in the slicer which aggregates all values? Just like there is Product A etc?
Wouldn't that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 5:50 am
If you have a slicer for products, then by default all products are selected which is the same as the ALL member.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 25, 2015 at 5:46 am
Viewing 15 posts - 841 through 855 (of 11,676 total)