i am trying to use the in operator on a table in the grouping and sorting windows - filter tab.
Expression := left(fields!field1.value,1)
Operator:= In
Values:= 1,2
I have tried multiple combinations (1,2), "1","2". None of them seem to work.
Would anyone know what is the correct syntax to...
Hi,
I have to create the report in the following format
A AA 2
AB 0
AC 0
B AA 3
AB 1
AC 0
Total AA 5
AB 1
AC 0
Now, I have done the easier part. The issue I am facing is since AB has a total of 0 in A, that row does not show up and similarly...
Hi,
I wanted to implement type-in prompt with similar functionality as picklist prompt. Picklist prompt can be implemented by using "IN" operator to allow for multiple prompt values. Similarly I wanted to allow the user to enter multiple values in type-in prompt. I have tried using the "IN"...
Hi,
I have configured IWR to IIS webserver. Below is the error I am receiving. Can anyone pls help.
"A severe error has occurred.
Please contact the system administrator for assistance."
Thanks,
Taruna
Hi,
I am trying to install Cognos Series 7.3 on a Windows 2000 Server. Everything works fine until I install IWR. As soon as I install IWR, Impromptu stops to repond and does not start-up. When I uninstall IWR and reinstall impromptu, then Impromptu starts to respond again. I would like...
have 2 Dimension tables, one view and one fact table. The dimension tables are fund and task.
Earlier the view table was joined to task and fund table.
View.Fundl = Fund.Fundl
View.Program = Task.Taskl
I am trying to change these joins to go through the fact table and still get the same result...
I have 2 Dimension tables, one view and one fact table. The dimension tables are fund and task.
Earlier the view table was joined to task and fund table.
View.Fundl = Fund.Fundl
View.Program = Task.Taskl
I am trying to change these joins to go through the fact table and still get the same...
Hi,
Is anyone aware of any best practices used in the industry to develop and test cognos reports and impromptu catalogs?
Also, what the Q/A testing methods (techniques) to test catalogs and reports.
Thanks.
I have created a drill through report in the Creater User Profile. When I open up the report as a user without "create/edit reports" privelege, I cannot drill through the report. How can I set up priveleges so that user can drill through the report but cannot edit/create reports.
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.