Recent content by stuartgmilton

Thanks for the helpful post.

Hey guys, I have never done a cascading prompt before - can someone run me through how to do one. It is using BO 6.5, but is then being accessed via WebI. Cheers, Stuart

Hey guys. I've now been told that during the install of WebI. THe company decided to go for the IIS aproach as opposed to JSP. THis means I'm not able to use drill down in WebI. Could anyone tell me how I could html link to another report tab within the same rpt file, for the required info...

Hey Hilfy, in your post you mention; You'll also want to create a measure for the prompt. Something like this: @Prompt('Select Report Type', 'A', ('Today', 'This Week', 'This Month', 'Custom Period'), Mono, Constarined) I have not created this yet, but it is required for the...

OMG! Right, I've finally gotten back to this after a while off and am working through Hilfys post. I already have a class called Date which contains all my date measures. I tried to create a measure with the 'Select' text of; @Prompt('Select Report Type', 'A', ('Today', 'This Week', 'This...

Cheers Guys

Thank you so much Hilfy, obvously I've a bit of work to do to change to SQL but thats extremely helpful. I'm gonna have a go at setting it up this morning. Thanks, Stuart

Ok Cheers.

I guess what I'd like, is an initial choice between day, week, month and custom. If they select custom then they would be further prompted for the start and end date. No idea if this is possible. Cheers, Stu

And the bit I got lost at was the heirarchy. I have created the basic dimensions in the universe and the count measure. I assume this is done in the universe?

Hey guys, I have a report which our user would like to view for the following periods; 'Today', 'This Week', 'This Month' & 'Custom Period' This report is going to end up being accessed via WEBI. Can anyone give me any ideas? Cheers, Stuart

Hey guys, I'm back doing BO after 3 years and have forgotten just about everything. I'm trying to create a drill down report based on the following; 1.Number of calls closed by department 2.Number of calls closed by employee 3.Priority of calls closed. 1 being the highest level and 3 being...

Thanks mate, I had never found that other forum before. Cheers.

Forgot to say, we're on BO 6.5.1

Hey guys, I am back doing BO after a good 4 years and have forgotten alot!! We have a SQL SERVER 2005 DB. I would like a number of objects in my universe along the lines of; Todays Date (Date) Todays Date (Date & Time) I have tried using Now() but for some reason this doesn't parse. Can...