Search results for query: *

If I write a report in full client v6.1, which has synchronised queries (multiple data providers) based on the same universe (and in some cases an excel spreadsheet as an additional data provider), can I refresh this report in WebI? Thanks

Another option may be to do it in the report. Create a variable, which you define as a measure, which just has the dimension <date value> from the second data provider as the formula. Make sure that you still unlink the dates in the report data manager. Create another variable to do the days...

You could hold the security table(s) in a linked universe. Create an empty Universe in Designer. Go to File > parameters and on the Link tab click on the Add Link button. This allows you to navigate to your vendor's universe (which has to reside in a repository) and click on Open and OK. The...

I made the store a detail of the employee number (seems the wrong way round but it has to be this way as employee number is what links the 2 data cubes) and used this as the master detail for my sectioned report and ....... it now totals up correctly, (apart from one area but I pretty sure its a...

Thanks everyone. I've tried Sri's idea already and it doesn't work. It does a strange thing. If the Store has only 1 employee, it works. If the store has more than 1 employee it gives the total for the last employee in the block. I suspect I'm going to have to do a bit work on the Universe so...

I have 2 queries. Query1 returns Employee Number and Store Name - both of these are dimensions. Query2 returns Employee Number and a Cash Value(pay) - Employee Number is a dimension cash value is a measure. I now create a 3rd report based on these 2 data providers, with Employee Number as the...

I have a report which returns the hours that a person has worked in the last 6 months. Not all of the employees will have worked every month in that 6 month period. I want to display a summary report which shows the total hours they have worked in the last 6 months AND a total of the last 3...

When you export the Universe do you get the dialog box saying something along the lines of ... a universe of this name already exists. Do you want to overwrite? If not, then there is something different and you are not replacing 1 with the other. The file name has to be the same to overwrite...

Is there an easy way using formatting or local variables, to round a calculation down to the nearest 0.25. For example if the result of a calculation is 15.16, I want it to display 15.00; 17.34 I want to display 17.25. I can achieve it using a long winded 'if then' statement looking at the...

Thanks. Gill has now left the server.

We are running Impromptu through a Citrix server. When the fish starts swimming it hammers the server as the users screen is constantly refreshing. Is it possible to turn the fish off?

Excellent. I love it when the solution is an easy answer, you just feel a bit of a donkey for not knowing it. Thanks for your help

OK .... was doing the join the wrong way round .. d'oh. I've now got 1 long list which has everybody and their contractual hours and another which just has those people who have sickness. But I still have a problem. I've got the main query which has contractual hours in it and the sub query...

I can't do it as a sub report because if I link on Employee ID I only get those employees who have absence. I want to be able to show those employees who haven't got absence and those who haven't got absence in the same report. I think the person information is on 1 table which is outer joined...

I want to bring back in a report all of the people in my organisation who have had absence and the total days absence they have had - this I can do. I also want to bring back everyone in my organisation and their hours of work - this I can do. The problem I have is that I want these 2 bits of...