COGNOiSe.com - The IBM Cognos Community

Would you like to see some animated tutorials?

And what would you like to see?

Here's an overview:

http://jeroendegraaff.nl/tutorials/

Current available online tutorials:

- Percentage of total column
- Creating a column-indented cross-tab
- Forcing data on 1 page
- Creating dynamic percentage bars based on data
- Creating IQD's using ReportNet
- Creating a Master-Detail Report
- How to enable image browsing
- Creating a Report Template
- How to use a template
- Creating cascading prompts
- List item with alternating row colors
-  Creating custom gauges using Dundas Gauges .NetÃ,  < NEW

What happened to voice?

Great Job Jeroen !!!

I had done a couple of videos using Snagit and am embarassed to say that it does not compare in any way with your slick production values.

Is Camtasia studio freeware?
NKT

I would love to see more. They are very helpful in many ways.

Maybe a little something on how to create a simple report in RS or QS and then fix it so other users can use it as well? Or, something on tabular sets and a good use for them?

Nope... Camtasia is shareware...

But you liked it? That nice to heare :D

And... CoginAustin.. just as you replied I've got another brand new tutorial :D

Have fun..

I'd suggest something on setting up conditional formatting for, say, a traffic light report or highlighting. If you have a spare couple of days ;-)

Great tutorials!

It's already in there...
Look at the percentage bars. Imagine them rotated 90 degrees  ...
Bar responds to percentage value.... only there are 11 posible "traffic light combinations"  instead of 3

Thanks for the tutorial, I appreciate your efforts, they will benefit a lot of CRN users.Ã,  I did have some trouble as my browser could not contain all of the tutorial frame without scrolling.Ã,  Is there a browser setting or screen resolution I need to adjust for optimal viewing?

Thanks again!

Don

How to create a report that contains 3 pages, and these 3 pages should be repeated for every project?
Olha

screen resolution = 1024x768

Upcoming tutorials:
1. Master-Detail
2. Report containing 3 pages, and these 3 pages should be repeated for every project? << Have to look in to it..


Btw.
If you have a request. Formulate it using the "Go Sales" package supplied with your CRN-installation, that would be a great help for me :D

I am new to cognos . Can you provide me with some steps how to do it?

thanks,

Did you try any of the manuals? Look for sections on how to create Templates.

Thank you very much! :)

I just want to add my personal thanks for these tutorials. They are very very helpful!


ReportNet Addict: you're welcome...

Hi,

Great tutorials.....

Those are really helpful to all....

Hope we will watch some more animated tutorials....which help us to do better....
Hope to have tutorial on that topic which is difficult to explain and which needs demonstration on that topic...
keep uploading more tutorials.....

Thanks a lot....


ReportNet Addict: you're welcome...

Just give me some cases/ scenario's based on "Go Datawarehouse" / "Go Sales and Retailers" and i'll create the tutorial if possible.... :D

How to create, in FM, 3 tables. 1 fact and 2 dimensions with one of them conformed or both.
Then create a report to show variance between 1 total and another total..

lol.. sorry.. I am having real issues getting variance to work between 2 fact tables  and have try numerous ways to do it but none of them are good

Is it a FM matter of a ReportStudio matter?  :p

That is a very good question..lol

I can get it to work in RS if I add a calculated field.

I can't seem to get it to work by adding a calculated field in FM and using it in a list report. It always gives me the error "illogical multiple fact table". So I guess FM? I wanted the calculation done so it would be available to users to use without having to do it themselves.

I think I wouldn't try to solve it FM, I would do it in RS....
But did you put the calculation in the conformed dimension or somewhere else?

btw...
I think it's time to start a new topic, because i think this ain't the right topic to discuss this.

I have a Budget fact table and an Actual fact table for Financials

They share some conformed dimension like Time, Business Unit

Each fact table has an Amount. I am try to get this type of list report:

January $budgetamount $actualamount $variance $percent_variance

For some reason adding the calculation to FM does not seem to work and breaks everything. (Atleast the way I am doing it break everything)

I posted this question here:
http://cognoise.com/community/index.php?topic=328.0

Hey ReportNet Addict,

Your talents are wasted on the IT industry! ;D (Hollywood beckons)

Great tutorials and thanks very much for sharing.

Appreciate the marketing at the end of the clip!

Cheers,
Jon

This is an excellent Tutorial. I have a small doubt.

How to hide the column name and the underline from the drop down list in a report ?
can anyone of you please give me a solution for this ...?

you can see it in the last tutorial cascading prompts.

Reoprtnet Addict - The best kind of addiction. The best tutorial so far on reportnet...keep it going!
- D!

Jeroen -

Your tutorials are EXCELLENT!Ã, 

I would (and already have) recommend them highly to anyone who's learning CRN.

I especially like the way you show things in stages - showing what the report looks like at one point, then adding to it to make it look better.

Your efforts are greatly appreciated, so.....Ã,  Ã, 

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, ! ! THANK YOU ! !

Thanks for the tutorial, it is very useful.

If u can add Voice no turning back ...This is the best on-line Demo I have ever seen in my Life

Quote from: Sudha on 01 Oct 2005 03:35:42 PM
If u can add Voice no turning back ...This is the best on-line Demo I have ever seen in my Life

Are you sure? I made this tutorial for deaf persons too

Great Tut. Do you have one or able to tell me how  to attach a image to an asset catalogue report (say office furniture)that shows a picture of each item within the report. Eg. row one: asset name, description, procurement code etc and then a image of the asset.

The tutorials are great and very hepful.

can you please demonstarate of using child tables, or tabular sets.

Thank you Olha

Can you give a brief example?

How to create tabular set which consists with two tables:
table1: product information (name, type,line)
table2: order information

then create a list based on that tabular set (will have all items from both tables)??

thanks, olha

Thanks a ton for the tutorials
they are an elixir for any one who is learning CRN
Thanks again !!!

  :D

Good ones
thnx
User

Hi Mr. Addict
The url http://www.jeroendegraaff.nl/tutorials.  is not working??  ??? can you please check and let me know?? but http://www.jeroendegraaff.nl/Cognoise/ is working fine. :)
tnx much

Hi,

u have any idea on dynamic sorting on cross tab

The links are not working.. can anyone reupload please... :)