Recent content by UcfMike

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...