Viewing 15 posts - 1,996 through 2,010 (of 11,676 total)
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 26, 2014 at 12:45 am
raghavag7 (8/25/2014)
Here i am using MDX Queries,Manually Created Report parameters, after that mapping to Dataset Query parameters.
...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 25, 2014 at 6:47 am
hoseam (8/25/2014)
Yes Scheme Code is s_code is the table.
OK, but none of the codes - error_code or schema_code - from the sample data appear in your result set.
Why is this?
To...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 25, 2014 at 6:44 am
hoseam (8/25/2014)
what do you mean?
The schema_code column in your result set, is this the s_code column from the sample data?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 25, 2014 at 5:46 am
Where do the schema_code come from?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 25, 2014 at 5:28 am
How did you create the parameters?
What did you configure for the value of the parameter and what for the label?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 25, 2014 at 4:16 am
Nice question Steve, thanks 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 25, 2014 at 12:32 am
Jeff Moden (8/22/2014)
Koen Verbeeck (8/22/2014)
Found it 😀Apparently default values for parameters need to be constants, not other functions.
http://stackoverflow.com/questions/470664/sql-function-as-default-parameter-value
Boohoo SQL Server.
I'm sure it's obvious to you but, in case anyone else...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 9:34 am
Luis Cazares (8/22/2014)
Koen Verbeeck (8/22/2014)
Ed Wagner (8/22/2014)
Thanks, Simon. The only one I can't see is Koen's. Everything else seems to functioning normally.
I changed my avatar recently.
I re-uploaded it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 9:33 am
SQLRNNR (8/22/2014)
Ed Wagner (8/22/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 7:49 am
rkl1v09 (8/22/2014)
The where clause that I have used isn't correct. And that is the bit that I am stuck on.
In what sense is it not correct?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 7:36 am
Found it 😀
Apparently default values for parameters need to be constants, not other functions.
http://stackoverflow.com/questions/470664/sql-function-as-default-parameter-value
Boohoo SQL Server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 6:49 am
Ed Wagner (8/22/2014)
Thanks, Simon. The only one I can't see is Koen's. Everything else seems to functioning normally.
I changed my avatar recently.
I re-uploaded it and now it seems...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 6:18 am
jacksonandrew321 (8/22/2014)
I downloaded the link, but couldn't have got the right way to perform development of cube. Please describe the steps to perform the development process of the SSAS cube.
That's...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 4:44 am
rkl1v09 (8/22/2014)
The due date is coming from the database. So the report needs to run based on the day the report is run. For example if I run the report...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2014 at 4:14 am
Viewing 15 posts - 1,996 through 2,010 (of 11,676 total)