Search results for query: *

Its been found.

I have a document which is a one pager. When I run it in Desktop I get one page. when I run it in Web I get 2 pages, the second page seems to have been customised to give a bit of text and some notes with some of the actual results in. Editing the document I can't see any source for the 2nd...

Thanks for the info Sorry for my ignorance, do you mean exclude it somewhere within the Narrowcast application or exclude the process from running on the server altogether. Thanks again Chris

I have a problem where I am looking to rename the path where my images for documents come from. I have thousand of images attached to documents and to go through each one and replace would take far too long. Does anyone know a way of doing a mass replace in the metadata to change the network...

Good morning We are unable to send any emails via Narrowcast, we keep getting the following error message. Error transmitting to recipient [CC3FFC7249474ED68CB20CDFBBC18CE8] - 85018:Connection refused at host 221.xx.xxx.xxx[U607ST133::SE]:3588:[THR:0x960][02/09/2009 11:30:52.812][Level:Minor...

Don't know why it happened but since I posted the problem seems to have sorted itself out and we don't get the error any more. thanks for replying. Chris

Good afternoon I am using Object Manager 8.0.2, my data warehouse is Oracle 9i. Whenever I am copying objects across from 1 project source to another the tables within the Oracle environment are locked and we cannot load any data into them or change them in any way. This never used to happen...

Sorry I'm not a dba. What do you mean by stats, statistics have been computed for these tables I believe. Is this what you mean.

Good morning I am trying to do an update via a sql statement on a table containing 47 million rows from a table containing 250 rows. The structures are as follows Table 1 - 47 million rows Offer_id number(5) Branch number(5) item vachar2(5) Date...

Thanks nlim for your prompt response. I was really hoping you'd not mention SDK as we have not yet purchased it. I am guessing I will have to go through the reports and add the filter. Please confirm Thanks again

I would like to automate a routine to add a single filter to all my reports (100 reports approx). I was hoping that command manager would be able to perform this for me. Unfortunately I have been told by MSTR that the functionality is not yet available (will be added as an enhancement request)...

I've added month to the start and end date attributes and made it a parent of them both then tried it on just one of them but it still keeps coming back with the same sql as before. I think I may take another look at my data and see if there is any other way of doing it.

I've taken the level dimensionality out of the M1 metric and when I run the report it prompts for a month as it should but the sql comes back as follows. select a11.BRCH BRCH, sum(a11.VALUE) WJXBFS1 from F_LL_BUDG_BAL a11 group by a11.BRCH Its now totally ignoring the month I selected and...

Thanks for that. I think I am close but when I run the following sql it complains about the end date not being a group by. select a12.BRCH BRCH from PROMPT_MONTH_TEST a11, F_LL_BUDG_BAL a12 where a11.MONTH in (To_Date('2004-02-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')) group by a12.BRCH having...

I have the following data in 2 tables Table 1 Store Start Date End Date Value 1 1/1/00 3/31/04 100 1 4/1/04 12/31/04 200 Table 2 Month Name 2/1/04 Feb 2004 4/1/04 April 2004 Based on a prompt from table 2 I...

I have the following in a table Store Period Year Date Value 1 1 2004 1/1/04 100 1 2 2004 1/2/04 200 1 3 2004 1/3/04 100 2 1 2004 1/1/04 50 2 2 2004 1/2/04 75 I want to write a view to show the cumulative value by month...

It was an ODBC problem, now sorted and working. Many thanks to those who tried to help.

That didn't make any difference either. The formula is ok, when I copy the sql the report generates into Oracle directly and run it I get the correct result. I think it must be something in the settings I am missing.

Unfortunately I am stil returning only one result.

I forgot to add, the attribute does return the correct values in my development system but I just can't see any differences. Could it be somewhere in the project configuration that is making my live system only return 1 row. Thanks again