Search results for query: *

Chael, Are you saying that if I use the same prompt in two reports contained in a document, I will only be prompted one time for the two reports? thanks, hoohay

Justin / dbtoo2001, Thank you both for your input, it's greatly appreciated! Just what I was looking for! hoohay

Wondering if someone can give me detailed descriptions / contents of TNSNAMES.ora and SQLNet.ora files....or please point me in the right direction to finding descriptions. I've tried finding some information on the Oracle Website, but have been unable to locate any. Thx in advance. Hoohay

Thanks for your responses. The problem was.....I did not create anything inside the editor to connect the hyperlink to. Sorry for the confusion. I appreciate all of your help. Have a great weekend. -hoohay

Thanks for your responses. FLB - I cannot see the hyperlink when I run the Document in Desktop, and also am not able to see it in MSTR Web(asp). There is a hyperlink at the bottom of the Document that brings me to RebuildReport.asp. but I believe that this link shows up by default. hoohay

When I create a document with a report in it, and 'insert a hyperlink' into the document, I cannot see the newly inserted hyperlink when I access the document via Web Universal. Any ideas as to why? Is there a view hyperlink setting in Web Universal? Thanks, hoohay

In graph titles and labels, is there a macro that can show the value of a date that was chosen in a prompt? Something like %%REPORTNAME%%?. Thanks, hoohay

Thanks nlim, I would never have thought of this approach. thanks again for another dead on reply!!!! hoohay

nlim, You hit the nail right on the head. I set the filter properties of the metric to 'Merge report filter into metric' Thanks, hoohay

Does anyone have advice on how to: Create a prompt that shows only the valid or existing 'transaction dates' for a given 'Company' which has been chosen in a previous prompt? Can this be done? Thanks for your input. hoohay

If I create a report with only an attribute on it (i.e. Company) and add a filter to the report that is for one company (i.e. Johnny Lightening's Kayac's), the report shows only Johnhy Lightening's, which is what I expect. Then I add a metric to the report, and looking at the SQL, I see that...

Thanks Nate, this did the trick, I appreciate it! hoohay

When I try to create a report in MSTR Web Design Mode for blank report, the filters that I have created do not show up in the Report Objects box? All of the metrics and attributes do show.....??? Thank you for any help, hoohay

There is a .bad file created for these rows. You configure the directory where this is sent to in your session editor

Thanks Spod, This was very helpful!

Can someone give me a clearer description of apply simple syntax applysimple("?",?,?) describe what these values are or could be, what is #0, etc. Thanks in advance,

thank you all for your responses! great help! Nlim, As in your first response, i have created the year, quarter, and month attributes using the date functions, but when assigning parent / child relationships, there aren't any links between the attributes. Will creating a hierarchy for the...

Thanks for the reply User14. A few related questions.... Could I, for example, for quarterly data, create filters that have 'date between 01/01/02 and 03/31/02' for 'Qtr 1 2002' and use it on reports or in metrics? How would this limit our reporting? Would this lead to poor processing...

Thanks for your input mstrNate. I hope to reciprocate someday! hoohay

is it possible to construct attributes for a time dimension (year, month, day) out of a single date table that contains a transaction date field only? or do i NEED to create lookup tables for year, month, day, etc.