Hmm,
I think I'm going to have to work on this some more. Thanks guys for the suggestions, unfortunately they don't work for me so far!
If I find an answer I'll post it here.
Beck [wavey]
"You can do foolish things, but do them with enthusiasm"
Thanks Paul,
But I have tried that too.
I am using SQL Server 2000. To include all values in HOURS even when there is none in OBSERVATIONS means I need an outer join on the HOURS side.
This might work if my schema only had those tables, but unfortunately (as in all things) it is more...
I assume that you can create universe objects seeing as you talk about @prompt.
In that case you can do this without using two data providers. The way I do it is to create a new measure object which has the @prompt in it's select clause. To make it work the prompt has to be aggregated e.g. by...
Thanks promero,
But I'm still confused. I did try the tactic of having 2 data providers thus:
DP1: Date (dimension), Hour (dimension), Duration (measure)
DP2: Hour (dimension)
Where the Hour dimensions in each are linked, and Hour in DP1 only has values where a Duration was recorded, but Hour...
Here is my problem. I have a chart with a measure of 'Duration' by Hour. Not every hour has data but when I chart it I would like the X-axis to have the full range of hours from 0 to 23.
The Y-axis has a 'Scale' option (because it is a measure I suppose) but not the X-axis (because it is a...
Thank's jeter. But if I want to use it, I wouldn't know how to. Is there information available on this unit and what is required to make it functional?
When we purchased our C6/16 Meridian system, it came with a Remote Access Device. I think it's a NT8B80. My question is, What is this used for and should I connect it to our system. If it is a useful device, do I need something eles for it. It has a standard 25 pin D conector on it that, if I'm...
Does someone know how to toggle the sound on and off on the dial pad buttons? I have a couple of sets that sound a tone when each button is pressed, and some that don't. I haven't been able to locate this feature in any of the manuals that I have.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.