Search results for query: *

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...

It is line only? Not sure how to do this, as I can't find alot of documentation on the charting.

Hi folks, I've been asked to created a new chart which is split between having a few stacked areas and 1 line. So far I have managed to get the line to appear but unfortunately it has the boxes on every data point. How do I get rid of these?? Cheers, Stuart p.s. All I have done is created...

So, anyone had any bright ideas? I've just about had enough of battering my head against a brick wall!

I've gotten as far as this: '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() OpenFile() Main = DTSTaskExecResult_Success End Function Function...

Hey folks, I have a major issue at the moment. I am geting sent a csv file to import using a dts package. It comes in a standard format, but.... One field keeps having a double quote every so often. Does anyone have any code that will allow me to convert this to 2 single quotes or 2 double...