I want to open a text file in Notepad/Worpad itself. However the hyperlink in 'Go to URL' opens the content of the textfile in a seperate sheet. The goal is...

Dear Enthusiastic,

You helped me in the right direction. A peer of yours (Jerry Nee) pointed me also in this direction. The tested solution is:

Create Member CurrentCube.[Measures].Measure1

AS

[Measures].Registrations / [Measures].[Empcount],

Visible = 1;

SCOPE([DimTime].[TimeHierarchy].[Month].members,[Measures].Measure1);

this...

Tnx for your reply. I'm sorry my description was not clear enough, but you got the picture almost right. Your examples (Year level and Month level) are normally the case...

I do not know whether this is still a problem, but I encounter something familiar. I've got in my SSRS report a table, a graph and again a table, with...

Thank you all for your help. I'll go for the function:-). Indeed the check does not appear to work all the time.

I would like to avoid the use of a function or is that too naive?

Actually, I did that already:

select .....

isnull(sum((grens_correctie_C/7) * dagen_D),0) as G

from ......

(so indeed the 'isnothing' part is a bit obsolete)

Some remarks:

1) Dimensional modelling means denormalized dimensions and normalized facts, so the argument of duplicate data is not valid

2) Treat Date and Time as different dimensions. For the Date dimension...