Search results for query: *

Thanks AceMan1 Haven't tested the code yet but the concepts are far more elegant than mine. Will give it a whirl in due course.

Thanks for the thought PeteG but I am not much of a genius when it comes to arrays etc[sad] What I did do was create a seperate query for each of the columns I am testing. eg for column Global App class SELECT AssetID, Asset_Name, Status, Updated, Updatedby, Own_grp, Own_sub_bus...

Hi Team I have some data that changes and gets an update date whenever a field is changed. I am trying to report when a row has changed. I can get pretty close if I take out the update date using a group by in conjunction with a dedup query but am not convinced I am getting the correct values...

Nice elegant coding thanks.

Thanks Skip I actually went and pinched some code you had sent me previously about reading data in columns and reused that with delete function. For Each rec In .Range(c, c.End(xlDown)) wks = rec.Value Set ws = Sheets(wks)...

I have a macro that cycles through some data and creates worksheets named with the data. After I have created the sheets I want to delete them and keep the ones named so that it is ready for the next cycle. The code I have Dim wks As Worksheet For Each wks In ActiveWorkbook.Sheets...

Thanks Very Much Skip. Works like a charm. I have bit more to do in the "do your stuff here" section like saving the file naming it for each of the values in row 1 eg 170A.xls but I will try and work through this myself - all part of the learning experience. Nice of you to clarify the populating...

Hello, I have data in multiple columns and rows in a spreadsheet. I want to start at cell A1, read the value, perform some functions then move to A2 and so on until all the data in that is read I then need to go to the next column so it would be cell B1. Some sample data is below: 170A 150B...

Howdy Sri, It's been a while since I used hotfiles and then it was on Impromptu V6. As I recall you create an impromptu report and save as, and in the drop down list you select hotfile ( I forget the file extension but I think it is .ims) to any directory - I personally would prefer it to be on...

Hi All, I have created a stored procedure in an Oracle 8i database. I am using an Impromptu V6 report to retrieve the value sucessfully. The report uses the following: call EDM.PROCWRSTCUSTCOUNTS(?strStartDate? IN, ?strEndDate? IN, ?TotalCusts? OUT, ?15PerTotCusts? OUT, ?15perUCMOS? OUT...

I was after some code for Oracle that gave me a financial year by months with running totals and not being an expert thought something would be available on the web but couldn't find it anywhere. The financial year in this case was from the 01/04/2004 to 31/03/2005 but with a small modification...

Hi Team, I am running a macro in 6.6 on my PC that opens two reports in the same session of powerplay. the code is: [code] option explicit sub main dim objPPApp as object dim objPPFilterReport as object dim objPPChartReport as object dim objFilterReportRow as object dim sDateFound as string...

Hi Dr Lex, Had a similiar experience but with Oracle. The running sum function would work when created by Impromptu and even when I turned it into freehand SQL run via impromptu. It would not work when I tried to run it via toad on the same database - I didn't need to resolve this...

Sure you can create a development environment. Create a directory somewhere ( network drive, PC anywhere ) call it Cognos Dev. Have subdirectories called Catalogs, Reports, Macros, Prompts or whatever structure you want and copy your production stuff into these directories. Hack away to your...

On the face of it this seems like a fairly big question where you would need to know the steps to creating jobs, heirarchies, dimension and fact tables in DecisionStream. A summary suggestion would be for you to use DescisionStream to use your single fact/dimension table as a source and create...

I find it is usually that some one else is using the catalog to create reports. You may need to take a copy of the catalog and put it into another directory, make the required changes and copy it into your production environment when no one is using the original. I would generally adivse you...

Thanks for that Team, I used a calc along the lines of (DurationMinutes / 1440) - integer-divide(DurationMinutes / 1440). Seems a bit clunky but it is working fine, for integer-divide I think floor may have worked as well. Regards binway

Hi Team, I have a field that is in minutes called DurationMinutes. I can calculate the days by doing DurationMinutes / 1440. This will give me a figure with a decimal eg 3559 minutes = 2.471527 days. I would like to get the remainder of .471527 and convert it to minutes by * by 360...

Thanks jobjoris. I went to the www.forumtopics.com/busobj website that the great skrandel refers to sometimes and looked up Prompt order not working in Webi. It is pretty long thread but the solution as copird from there is: Not sure if this 'bug' has been resolved yet but here is my solution...

Hi Team, I am using Webi 6 to create my reports. I have created prompts in my Universe with the All functionality as described: (@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR ('*'...