Search results for query: *

Thanks Blom. I guess I will finally make the switch. I did enjoy the guarantee that it would be you answering my questions here on Tek-Tips.

I have a list report that needs to use different members of my ledger (Budget and Actual), date (current month, prior month, prior year), and measures (current month vs YTD). I can successfully create the report using tuples for ledger and measure when the date is applied as a filter. In order...

Good Luck! Hope you are able to figure it out easily.

Ty, I am sorry for leaving you hanging like this! After reviewing my report, I realized I defined the ledger ([Actual]/[Forecast]) as a hidden column and thus used a standard measure. I tried to create the waterfall that you are asking for in a blank template. I am able to waterfall where...

Hey Ties, I wanted to thank you for your help with this. I was able to figure it out finally! Basically what was happening, was that I had a calculated measure that was making decisions in one hierarchy (Income Statement) while my crosstab rows and filter we being defined in another (Company...

Hey Ty, Please forgive me as I am rather new myself. Would you mind explaining what you are trying to do in more detail? I have a report similar to what you are trying to do that provides Actual up to the selected month, and then Forecast for the remainder of the year. My months only go...

I have attached my report. Maybe you could have a look at it. Thanks.http://www.mediafire.com/?ha8pv0bu49clvcs

I'm at the mercy of DBAs backlogged with months worth of work. If I was able to fix the SQL so that it could compile (replace all of my tokens with a fixed member), would I be able to do something to fix it (assume it is stitching)? Let me set up this mediafire hosting and I will load my report.

I've tried after auto-aggregation, but it gives me the same results. I've even tried aggregate([Revenue] within set [Branch]) thinking this would force the crosstab to evaluate at the branch level, but this too did not change my results.

Thank you Blom. Your explanation for the scenario makes a lot of sense and I feel this may be indeed what is happening. Unfortunately, I am unable to view the SQL due to validation errors caused by my token (this occurs in several reports, but they all work as expected). Assuming this is the...

I have had my entire team look at the following issue and none of us can figure it out. I certainly hope you can. I have a report with 4 crosstabs; each one gives a little more detail than the level before it. They all refer to the same query 1) Aggregate(Division) (1 Column) 2) Division (As...

I have a list in my report that uses a custom grouping based on the name of the object. For example, Case when [Name] in ('Cat','Dog') then ('Mammal') When [Name] in ('Lizard') then ('Reptile') ...etc... End In some circumstances, the grouped items will repeat themselves based on level below...

You will need to have a data item for country. This would typically come from the database, but from the sounds of it you would have to derive country from the country-state combination. To do this, create a new data item and use the following definition: substring([Country-State], 1, position...

I figured out a solution that required using Tokens. This allows my tuples to be flexible but avoid using case when statements.

This is a very peculiar situation and I am looking for some assistance to make sense of it all. I have a report with a parameter for Brand (without a value prompt as this is a pass through value). This displays on the parameter list for the pass through. I am adding a token prompt called...

I have a report with a series of crosstabs and graphs that works fine with a static measure of Current Amount or YTD Amount. I created a prompt in the report so the user can switch between the 2 measures. I created a calculated measure using case when else. I added this calculated measure to my...

The issue that I have encountered is more of just a nuissance and would like to fix it if possible. In my report, I have several Crosstabs. Each crosstab has drilldown enabled and works fine. What I am experiencing, is when I scroll down to the bottom crosstab and drill into, the webpage...

Hello All, I am pretty new to Cognos, but have been having fun creating reports with custom sets using unions for items in the same hierarchy level until I realized this causes the issue of losing the ability to drill up or down. Is there anyway to enable drilling up/down for these sets? I...