Viewing 15 posts - 1,081 through 1,095 (of 1,168 total)
Thanks for the reply Craig. I'll play around with that and report back.
November 13, 2012 at 10:45 am
Hi and thank you for the reply. Yes they all have the same schema.
November 12, 2012 at 2:03 pm
Ok thanks for the note, I missed that. I guess haste does make waste.
November 9, 2012 at 10:41 am
You have an orphaned fact record, with no key lookup to the Dimension. As mentioned process the dimension. You may have to consider how the data is moved, (what the...
November 7, 2012 at 1:03 pm
I use
SQL Server 2008 (or other year version) MDX
Step by Step
It is not light reading but it brings you into the world of MDX in at a comfortable...
November 7, 2012 at 12:30 pm
When you create a report it is customary to point it to test data. When a report is published the connection should be pointing to a live database. Since the...
November 7, 2012 at 12:05 pm
Since this creates a table you are looking at a relational database that happens holds dimensional data. These serve as the basis for the cube (itself a database-non relational) but...
November 7, 2012 at 11:46 am
When your code reaches the statement
if (@Due = 'All') set @sql = 'Select * From ##temp'
It is realising that @due has not been declared. The '@due' in the string above...
November 7, 2012 at 11:18 am
Lowell's solution is a good one. The Image datatype is deprecated thus the need for varbinary(max).
November 6, 2012 at 12:02 pm
Hi - If I understood correctly :
It looks like your first step is a [boxes] entity/table.
A stored procedure could go through the order, determine how many boxes are...
November 6, 2012 at 11:56 am
I suggest also running
dbcc useroptions
on the database(s) the report points to.
This will let you know for sure the language setting used on the target.
Regards.
November 6, 2012 at 11:44 am
"But something like "amount of purchases last 12 Month" < 6 might be useful, and categories might mess this up "
A good point but it still all fits. If the...
November 2, 2012 at 12:08 pm
Hi - to answer your question, create a domain admin account on your network if you haven't done so already. Use this same account to run the Agent service on...
November 2, 2012 at 12:02 pm
I suppose create a trace in profiler to see what connections to your database are coming from other servers and using the account that ssrs is running under. If the...
November 1, 2012 at 4:54 pm
Viewing 15 posts - 1,081 through 1,095 (of 1,168 total)