Search results for query: *

Lilja: I think if you set the filter on the catalog level on the field of the prompt value ..it will accomplish what you are looking for ..that way only the values you want will b available in the catalog and that will be the only values showing up in the prompt.....I hope I understand what you...

Yes oso1234 it should do it John Organ MIS

oso1234: You need A Powerplay Transformer to be build the model that will generate your cubes....Powerlplay will be the software to generate the reports....needing impromptu depends on what kind of reports..over here all our detail reporting goes with impromptu and all summary reports are in...

Bajwa: Just wondering why you prefer to do it in one page....cascading prompts are designed to work with multiple pages..and can't really think of any use if it is in one page..you might as well do multiple prompts cos that will serve the same purpose. John Organ MIS

mvchaudhari: Take a look at your filter on the report and make sure that you are not using the prompt value with an "=" sign.....you can also check out GRIFFINDM FAQ on prompt...it covers almost everything u need to know..I learned all mine from his FAQ.....Jon John Organ MIS

farhan4real: The cognos pdf files that comes witht the software will provide almost everything you will need..then if you have specific questons..you can do a search on this forum most newbie questions you might have must have been addressed here at one point or their..so do a keyword .then if...

DoubleD: Yeah I took that into account before copying to live location John Organ MIS

drlex: Yes you are right..thanks......looked at the log...saw that ...so I set it now to run somewhere else and then copy to the live area...that will fix the issue..thanks again..Jon John Organ MIS

Hello all: I have this command line in a batch file and it is scheduled through windows scheduler for simple automation: C:\program files\Cognos\cer3\bin\trnsfrmr.exe -n2 -s -nologo "X:\Cognos\Transformer\Models\admtransformer.pyi" I have been using this for awhile now..I actually got this...

tostrowski: I copied and ran and it ran.......I added just one line.....it will be indicated by the ** sign... Sub Main() Dim objImpApp as Object Dim objImpRep as Object Set objImpApp = _ CreateObject("CognosImpromptu.Application") **objImpApp.Visible True** objImpApp.OpenCatalog _...

1HRlabs: I changed your getObject to CreateObject and addedd open catalog it worked fine for me hope it works for you Sub Main() Dim objImpApp As object Dim objImpRep As Object Set objImpApp = _ CreateObject("CognosImpromptu.Application") objImpApp.Visible True...

rpmrob: I'm in an educational environment too, the Cognos Books that should come with your transformer should be a good place to start and this forum will be of a great help if you ran into some problems that you can't figure out...believe me I have learned alot from this forum....KUDOS!!! to...

Silban: YOu might want to look at your measures, 99% of the time this type of issue have to do with the measures in the cube John Organ MIS

Jvaneert: Open the catalog the catalog that is associated with that report then Catalog --> User Profiles --> Database (Tab) Under the Database Security Options select the radio button Database Logon and enter your user id and password and you won't be prompted again. NOTE: You have to select...

Fchern: HOw did you reset the creator password? John John Organ MIS

Thanks DoubleD...issue resolved from your suggestion..thanks John Organ MIS

Hi all: I have this issue, we are going through upgrade and I have a table called PS_STDNT_TEST, this table is used in our catalog but one field on this table changed from DATA_SOURCE to LS_DATA_SOURCE, then Ihave this issue: CATALOG -> TABLES on the DATABASE windows, I see the table alright but...

Thanks Reece....that did it for me..Thanks again John Organ MIS

Hello all: There must be something I overlooked..this is my situation: I created a TYPE in prompt on the catalog level that asks the User to type 'D' if they want Day students, 'E' if they want Evening students and 'A' or nothing if they want both day and evening students. Then my problem starts...

JGIRL: Go to Catalog User Profile Database Tab Database Security Options Make sure that this options is selected: Prompt for Database Security Hope this helps...John John Organ MIS