Search results for query: *

I was handed a new model. In Query Studio, when I select a query item I get a prompt. I assume the filter has been created in Framework Manager, but I can't find the filter. Is there any other place it could be. It's not in query studio, because this happens with a new report.

Why do you need the Case Statement, why not use the if then else? I think your parentheses were in the wrong place: IF ([SQL1].[TXTYPE]= 'OPENING' )THEN ([SQL1].[AMOUNT] > 0 AND [SQL1].[AMOUNT] <=50 )ELSE ([SQL1].[AMOUNT] < 0) Make sure you put this in a filter.

What about for a dimensional model? I'm worried about complexity and speed on the FM side. I know these calculations are pain if they're done on the report side. Can you think of any reason why you would want to take a dimensional model and flaten out in FM? thanks

Calculations like YTD, that have to be query items in the report. Is it easier to create them in the database or in the Framework Manager? Opinions Wanted

Is it possible to copy query subjects between Framework Manager models?

Awesome Again Blom. Thanks.

Has anyone else had problem with date formatting in a crosstab when the date is either a column or a row?

No, I actually wanted to create a variable. This doesn't appear to be possible though, since Report Studio variables are mainly used for displaying, or not displaying content on the report.

Can I use variables in filters and query items?

Blom is correct as usual. You can get them to match up, but you're going to have to adjust the size and overflow, padding, and maybe even the margin settings.

By Cognos 8 do you mean Cognos BI? I use that combination and don't have any problems.

We never had full outer joins in our database view, though when joining up query subjects in our business views, we sometimes did. The only time I would check the sql in FM was when the reports didn't work properly. I found that I would have problems when Cognos was producing Coaelsce...

What is the difference between a Summary Filter and setting a Detail Filter to after Auto Aggregation?

We never got our views into true star schemas, but we got as close as possible. If you can though, that makes life nicer on the reporting side.

One thing we did do with our joins is this. this Diagram is rough but here it goes. if this was our database view [a]>--[b]--<[c]--<[d] We would roll that up, which is what you'll learn in the training classes to this [a]>--[b+c+d] but we would do it in our business view. You spend a lot...

In the database layer we did join the tables based on the ER diagrams. This is where I also removed all determinants, and set all of my query item attributes to unknown or unsupported. I created a namespace called business views and then created namespaces inside that called sales retail, etc...

We did get our relational database modeled in FM, and we did it without a datamart or data warehouse. Until our upgrade to Cognos 8, we had been using Impromptu for our reporting needs. The results between our Impromptu reports and Cognos 8 reports are accurate. As far as performance, I'm...

This may not be a great answer, but it's the best I could come up with for the moment. On another forum someone suggested the following: maximum(count(<exp>)) I tested that and to get it to work changed it to: maximum(running-count([expression] for [expression]) This will create a column...

I have a report with nested page sets. I have to change the grouping level of the lists in the report depending on the page. My initial thought was to try this in a query item: Case PageName() When 'Project' Then [Project] When 'Region' Then [Region] Else 'Unknown' End This doesn't work...

That's to bad. It still seems odd to me that Cognos would make it so easy to access specific crosstab intersections in Impromptu, but make it a chore in Report Studio. Thanks for everyone with their help on this.