Two thoughts come to mind. Firstly you need to make sure the web server has the appropriate print drivers installed. They are usually different versions to your client machines (e.g....

Just a note on units of measurement.

I have previously worked with many laboratory databases and there is always need for a unit conversion look up table for any sort...

walter.anto (4/4/2013)

---

Hello,

I have a problem to calculate the variance.

Here is the code I use:

Axis([Measures]).item(0)-Axis([Measures]).item(1)

Dynamically, the calculated measure makes the subtraction between the first measure and the second measure.

On the other...

What I mean is that ID's are usually foreign keys that link to other tables. In a datawarehouse you should be using surrogate keys for all your dimensions and link...

filipetatarli (3/25/2013)

---

I'm studying MDX and can't solve one problem.

To simplify there is a fact table (fact_Proc) and two dimension (Dim1 and Dim2). The structure is:

fact_Proc :

id int identity(1,1)

id_Dim1 int...

This works on the adventure works cube.

Post your query

WITH Member [Measures].[Something Made Up] as

(

[Measures].[Internet Order Count]

)

Select

{

[Measures].[Internet Order Count]

,[Measures].[Something Made Up]

}

On Columns,

(

[Sales Territory].[Sales Territory Country].&[Canada]

)

on rows

FROM [Adventure Works]

mbrady5 (3/18/2013)

---

Hi,

I'd like to change a field value in my main data source query using a parameter. I cannot figure this out.

I'd like to be able to use a parameter...

No need to have a separate fact table to store all those dates.

The ticket process is actually a perfect candidate for an accumulating fact table[/url].

If you are interested in a...

I made a typo in there sorry, left off a square brack and forgot the keyword "Member".

Yes it's always too early for MDX! Obviously by my error it was too...

yay!!

You can alias a measure in a calc:

With [Measures.[Yesterday Clicks] as

(

[Measures].[Click Count]

)

That's going to cause you problems though, if you want to show both today's and yesterday's clicks on the...

There's two issues here. Firstly MDX won't let you put measures on both the columns and the rows. Best to keep measures on the columns and dimensions on the rows....

Sharon S (3/8/2013)

---

Hi all,

I am trying to create the Expression equivalent of the following query:

SELECT count(TasksName)

FROM [db].[dbo].[testdetails]

where TopLevelProjectName = '40 Project Folder'

and TasksName = 'Project Info'

I basically need a...

Take a look at this for troubleshooting reporting services logs http://blogs.msdn.com/b/deanka/archive/2010/02/16/troubleshooting-subscriptions-part-ii-using-the-report-services-trace-log-file.aspx

These both look like different issues.

Stanja appears to be related to the SQL Agent, Vinny looks to be an...

Yes, I have created hundreds of reports of all different kinds, from all different datasources, including very standard items like invoices and quotes and very complex reports such as analytical...

At this point it might be worth asking an MDX master like Chris Webb[/url] (@Technitrain)