Viewing 15 posts - 1,996 through 2,010 (of 11,676 total)
Great question, thanks.
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.
...
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...
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?
August 25, 2014 at 5:46 am
Where do the schema_code come from?
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?
August 25, 2014 at 4:16 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...
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...
August 22, 2014 at 9:33 am
SQLRNNR (8/22/2014)
Ed Wagner (8/22/2014)
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?
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.
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...
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...
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...
August 22, 2014 at 4:14 am
Viewing 15 posts - 1,996 through 2,010 (of 11,676 total)