Search results for query: *

Hmm... it doesn't seem to be working. The distinctcount function doesn't seem to be supported at all by Cognos. And when I add a dataitem to the query like: count( distinct [Supplier Name] for [Invoice Year],[Invoice Month]) validation gives me "A syntax error was detected near 'count'".

Thanks for the info... maybe I'll be able to get it working in Report Studio, at least.

I have a cube created via transformer which does a category count on supplier name. If I go into analysis studio and use the Supplier Count measure by country, everything works. It'll show something like: United States - 100 Canada - 50 Mexico - 25 Total - 130 So I know that there are a total...

In my framework model I'm copying business level subjects and remapping them to new database objects and aliases often. I've noticed some odd behavior, though, when I use the "Use Matching Criteria" option to do the entire remapping all at once. If I drag the new database subject to the Remap To...

I tried turning off the Unique for the Candidate level and turned on Group By, adding to the candidate properties only those items that specifically applied to the candidate, but that didn't work either. The item level measures are still being overcounted. Does anyone have any idea of how to...

I've set up a consolidated report in framework manager with several levels of data. The data is about requests, each request can have multiple items, each item is sent to multiple vendors and each vendor could have come back with 0 or more candidates. The data has one row per candidate, or in...

Here's what I need to do... I have to create a pivot chart that breaks down the data about 4-5 times. At each break, I want to total/average the columns (which is very easy to do) and also show a the percentage of one totalled column as compared to the break above it. Example: GroupA DeptA...

I haven't really used JavaScript in brio yet, but what you could do is have the loop check a (global) bool variable every time it loops, and create a button that changes the value of that variable. while (condition) { ... program code here... if (b_stopvariable) break; }...