Building Cognos report with multiple filters?

I'm evaluating Cognos to apply against a benchmarking database with survey data related to advertising. The current proprietary system has about 200 different filters that are implemented on-the-fly as additional "where" clauses within the SQL engine. I'm trying to replicate some of that functionali ...

Disallow Cognos to use distinct for filters

Gargi Patel said: Ok guys, I am really new to Cognos. In Cognos when we try to create a filter on one of the columns, Cognos does a "Select Distinct Column name " for that column so that we get a list of all distinct values, I want to know if we can turn that off globally so it doesn't do a distinct ...

Filters in Analysis Studio Cognos 8.4

Thanks for your information in advance.I'm new to Analysis Studio. I've created filters in Analysis Studio. If I drill down the filters appear to remain, but once I drill up they disappear. Is there something I'm doing wrong or can you not apply filters that remain on drill down/up? ...

Cognos 8.3 Model Reusability

Lily Tsai said: Hi,I would like to know if anyone has tried to create a Cognos 8 model that is resuable in other models. We currently are an Impromptu environment that will be migrating to Cognos 8.3 in the next year. We currently have some Impromptu catalogs that are the same, except that there are ...

How to pass a parameter as a value to another Query Subject in Cognos 8

Jerome Basdevant said: Hi, Some of my report studio queries are unecessary complex because of the filters I defined.Cognos each time is inserting into my main query the query elements of the prompt query while I would like to only see the values of the parameter passed in it. For instance let's say ...

Communication between portlets causes problems with drill through - Cognos 8.3

Peter Seivers said: HiIam having trouble getting a drill through from a dashboard report to work properly when there is communication between the portlets on the dashboard. This is how the dashboard is set up: It is divided into 2 columns, each column with content viewer, now in the left column i ha ...

Cognos Query - XMIN causes strange results?

Olga Gedroit said: Hello: I have a report built in Cognos (via Report Studio) that has several prompts/filters. However, by choosing the correct 'filters,' the report is not bringing up the expected users, users that clearly do exist at the source. Using toad and the same filters (mimicking the expe ...

Security between Cognos and Analysis Services

Renato Montanari said: Hello friends, I have here an interesting question that, I believe, you have already faced or will face in the near future. We have a problem relating to security between Cognos 8 and a Microsoft cube (Analysis Services 2005). Our team received a request to create a follow-up ...

How to convert the SQL into a Cognos report (very urgent)

Venkata Guntupalli said: Hi,I have to convert the given SQL into cognos report without changing any of the functionality included in SQL. The SQL looks like having involved with Subquery and filters on indivual columns. The report will need a date range prompt. In the attached SQL, I have hardcoded ...

The use of variables in developing Cognos Report Studio reports

Mazi Merritt said: Is it possible to use variables when coding filters in Cognos reports? I'm trying to develop a report that looks at data only over 7 days back and highlights 3 consecutive times when a report job to fail. This is in Cognos 8.3. ...

Comparing Session parameters of External Environement to FM Global filters

Sriram H said: Hi,I have scenario where, i have to get external environment selected prompt values to cognos query studio.After user clicks the submit button(i.e. button named "Adhoc Analysis") in a web page,the user will be directed to a query studio environment. They will not be directed to a samp ...

Date filters in dimensional model

Koti Raghavendra said: Hi,I want to use date prompts in my report which is based on OLAP sources. If i put the date filters in detail filters my report goes for a toss. Date is not being used in my list. But i want ot filter the data oute for a certain date range.I am trying to get the dates between ...

Cognos 7.3 Drill Through problems

Greg Graf said: Hi i am Greg de Graf a new user as of today and i have a specfic problem regarding Cognos 7.3 Drill through. Currently i am using a powerplay report that consistenly shows the wrong results when drilling through to an impromptu target report, the same report that is the basis for the ...

Migrating reports from BO into Cognos

Has anyone ever worked on migrating the reports developed using Business Objects into Cognos?I'm facing lot many issues... Issue#1fact table has 22 million records, Time dimension table has 19K records. There are other dim. tables but the records are few in these. When I do a simple select from the ...

Cognos Impromtu Please help me with this

I have couple of impromptu report issues which have become a pain .We haven't been able to resolve and have raised a PMR with cognos also. Any input from you guys would help us tremendously as this has become a major production concern for all of us.1) We have come across several reports which have ...

jQuery What is "this" question, this one about filters

Greetings.I'm trying to get a list of forms from a DIV where the form's "done" inputis set to 1 or 0 .Why does this code throw an error ("this.done.value has no properties") ?var myForms = $('.actionForm', myDiv).filter(function(){return this.done.value==1 ; });I ...

jQuery Stackable rules/filters interface

I would like to build a stackable filters/rules interface ( field, operator,value ) like the one that Thunderbird uses to create message filters.I.e.( ) Match all of the following (x) Match any of the following:[ Drop down list of fields ] [ operator ] [ value ] + -You can add or remove filters with ...

jQuery attribute filters for blank string

Is there any way to match attributes that are an empty string usingattribute filters?For instance, I might have a lot of anchor tags in a file with an hrefof "". How might I write a selector -- ie $("a[@href='null']") -- thatwould match this? Unfortunately removing the ...

jQuery attribute filters for blank href?

Is there any way to match attributes that are an empty string using attribute filters?For instance, I might have a lot of anchor tags in a file with an href of "". How might I write a selector -- ie $("a[@href='null']") -- that would match this? Unfortunately removing the "n ...

jQuery Extensible filters

One thing I really love about jQuery is the ability to extend it easily. Like adding a new jQuery.expr which I have used to match special attribute to interface usage on my site. After creating a new filter for the subselector I realized that it could not be used with out patching jQuery, making it ...

jQuery Column Filters Plugin Help

I just found the really great Column Filters Plugin:http://plugins.jquery.com/project/ColumnFiltersRight now, you can only use it with tables, and, the tern you arefilter with, has to be the first thing within the <td>, so, if youwanted to use a <span> inside, or a link this won't wo ...

jQuery Combination of several filters

All,Here is a simple code:var cl =$j("input[class='inputbox'][value='']").parent().parent().filter("tr[class^='comdebt'][class!='comdebt1specify1'][class!='comdebt2 specify2'][class!='comdebt3specify3']").attr('class');as yo ...

jQuery Combination of several filters

All,Here is a simple code:var cl =$j("input[class='inputbox'][value='']").parent().parent().filter("tr[class^='comdebt'][class!='comdebt1specify1'][class!='comdebt2 specify2'][class!='comdebt3specify3']").attr('class');as yo ...

PLUGIN: jQuery Column Filters

jQuery Column Filters by Tom Cootehttp://www.tomcoote.co.uk/jQueryColumnFilters.aspxRey... ...

jQuery Selector filters don't allow descendent selection

I want to select all labels except those within a div of a givenclass, but the exclusion is ignored :/These work fine:$("div[class='t2-display'] label").append("Only expected ones");$("div.t2-display label").append("Only expected ones");These don't ...

jQuery Is it possible to add filters to the (validate) plugin?

The validation plugin is working wonderfully. On the server side,there is some processing like trimming the input field, lowercasingthe input field, etc... Is there an easy way to wrap the fields intosuch filters prior to processing so that the client check matches theserver check?The syntax I'm ...

jQuery [QUnit] broken modules and filters in latest

It seems like the latest qunit doesn't have working modules, is this aknown issue? (commit: 57d1a28a9f6c44204d46ad651711beb4f8642117)Looking at the code, it seems to have been broken due to commit25c0a978997c8be12c7ea39abf919403a06f7473The fix is just as simple, adding that one line back in made ...

jQuery Filters for UNanswered questions and UNsolved problems

Shouldn't there be filters in the forum for UNanswered questions and UNsolved problems? Are those not the ones needing attention the most? Or are they hiding in here somewhere? ...

jQuery Setting opacity overwrites other filters in IE

Not sure if this is the best place to report this, but anyhow..(if not where's best?)Line 4602 of jQuery 1.4.2:style.filter = ralpha.test(filter) ? filter.replace(ralpha, opacity) : opacity;... overwrites any other filters that are set (I'm greyscaling first), spose it should be:style.filter = ralph ...

jQuery Attributes filters not always working when using a context

all,I realized attributes filters do not work when a context is passed insome cases :$(span[style*='font-size: x-small'] > strong, context);Simpler selectors work (span[attribute] e.g.), so i came to theconclusion that it is the combination of a complex attribute filterand a context which ...

"Style Filters" and Internet Explorer

A little known feature in IE is STYLE FILTERSthey are not like CSS but a Filter TECHNOLOGY designed to add GRAPHICS-LIKE effects/Illusions to TEXT...They can be used to imitate Photoshop-like effects and Added To DHTML they can imitate FLASH, JAVA APPLETS etc... Since they are a IE only feature - th ...

Text Filters

I am trying to trash an old HOME folder(from osx.1) which for some reason seems to contain hidden Illustrator text filters. When I try to empty trash, am told it can't do it because Text Filters is in use. How do I disable text filters, (mac os x.2.3) or do a force trash or something? ...

Filters vs Folders

If I want to have my files arranged into seperate folders, usually I have to create a filter and a folder, and then manually edit both when I want to move things around. This is a big pain.Is there a way to automatically have folders and filters be the same? ...

Sphinx Error: too much attribute filters

I'm new to Sphinx, and when I'm making queries against searchd, I get a lot of "too muchattribute filters" errors. I can't find any good informations on google.Any ideas of where it come from ? ...

Sphinx How-to handle filters on "dynamic" attributes

I'm working on integration of Sphinx search on classified website. The simple search(fulltext + sql_attr_uint) is working fine.The website allow user to add many criteria about their goods (brand, models, options,etc...). All these criterias are save on three mysql tables.There is a part of my datab ...

Sphinx Question about using PHP API and FIlters

If anybody could help me with this I would be very grateful!Is there anyway using the PHP API in sphinx to setup 2 filters, Filter A and Filter B andget sphinx to return results which match Filter A OR Filter B, rather than the standardmatching of Filter A AND Filter BThanks in advance for your help ...

Sphinx Help with xmlpipe2 and filters

Having a spot of bother getting xmlpipe2 to work with filters.Here is my XML:<?xml version="1.0" encoding="utf-8"?><sphinx:docset>    <sphinx:schema>        <sphinx:field name="title"/> ...

Offensive Word Filters (must be javascript)

Got what is hopefully an easy question for people out there who know a lot more about Javascript than I do. I'm building a language filter for a Ning site that I administer. I looked into php for a solution, only to later learn that Ning does not allow for the introduction of php into its site (from ...

Sphinx ANDed filters

and thanks for this wonder :) Because it IS a wonder... I admit I rarely was sopleased in using a piece of OS :)My problem is: I'm coding a dictionary, in which textual expressions are catalogued bylanguage/script. Most languages are monoscripted (like English) but some have manypossible scripts (Ja ...

Sphinx How to apply complex filters scheme?

Seems sphinx only support AND scheme of filter combination?I've a table with salary field as:salary integerWant to apply such a filter combination: salary within [1000,2000] or [3000,5000] , Buthow to create the filters for sphinx? ...

Sphinx comparison filters

In the sphinx docs, it states that with the MYSQL binary protocol comparison operatorsare supported, and that these map directly to filters. I am wondering how these mapped tofilters? Are there undocumented comparison operators for filters? Does it map acomparison to a range filter? ...

hi, problem with filters

I am using PHP4 with IMAP for mail features.I have come up with a problem with mail filters(blocking a user...etc) written in Perl. The filters are working fine for incoming mails from other servers, but the mails are bypassing these filters for local mails.Can anyone please suggest what the problem ...

SphinxSE errors if filters are provided in 0.9.9 RC2

If I execute a query like this in the MySQL client on a Sphinx table,<pre>mysql> select * from sphinx_bodies where ((sphinx_bodies.query = 'bank'));+-------+--------+-------+-------------+| id | weight | query | document_id |+-------+--------+-------+-------------+| 24226 | 1 | bank | 5567 ...

Sphinx Multi-query optimization and filters

So - I really hate asking these sort of questions, but here goes...The new subtree optimization is great but it doesn't work when only filters are beingused, which is common for my faceted search.In the April blog post titled "Facets, multi-queries, and searching 3x faster" it ismentioned ...

Sphinx Using filters on string fields

We are creating a very large application where the usual date datatypes of commondatabases just don't fit our needs. Hence we decided to strings to represent the datetimedata (we need years that span from big bang to distant future).As for the search engine we are considering sphinx but we ran into ...

How do you create filters

I would lke to create a few search filters for my page by way of drop down menus. Does anyone know a good way or resource to teach me how to do it? ...

help me! coding! about IE filters not effect

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb23 ...

Populating area with AJAX and filters

I need some help thinking through something. I have a list of checkboxes on the left that serve as filters (ex: [] news, [] events, [] birthdays). On the right, I have a div filled with news articles, events, and birthdays, all sorted by date. The data in the div comes from three different XML sourc ...

Cognos 7.3 / DB2 cube disable

We have recently upgraded from Cognos 7.1 to 7.3 for use with DB2 and upon finalising installation, have discovered that the PPAdminTool.exe program which was originally included in 7.1, is not included in the 7.3 install.We require the PPAdminTool.exe to disable cognos cubes whilst refreshing them. ...

Trigger Password Filters?

I've run into a challenge; I need to trigger the password filters on windows (http://msdn.microsoft.com/en-us/library/ms721882(VS.85).aspx) using C++. I can provide the username and old/new passwords, but the application might not be running on the account of the before mentioned user. It doesn't ac ...