Recent content by Nunina

Mufasa: YES!!! That's exactly what I wanted. Thank you so much to you, and to all the guys that helped! Here's a star for you! [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

Guys! We have 8i and the gang have been using CASE without any problems. My actual problem is not the CASE statement. My problem is to be able to assign the Classification to each record based not on the id, but on the Reason... Please help! Thanxs! [gorgeous] Issys Pouerie Systems...

Thanks! That one, I figured it out. But the problem is that I could have more than 2 classif... In other words, I suposse my case needs another else so that it can "grab" the other ones. This is what I mean: If like '%cold%' then 'WEATHER' else if '%bad%' then 'PLAYER' else if '%fraud%'...

Hi Guys! I have a table that has the reasons for loosing a game. This table contains the following fields: ID, Reason. ID REASON 1 FRAUD 2 LACK OF UNIFORM 3 BAD HITTER 4 COLD BAT 5 BAD COLD Now, I'm trying to make a query (I will integrate it into an ETL...

Hi Is just that is kinda long, and it has a database linked to it. But I'll be trying liamm's suggestion today, and I'll let you know. [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

But is there any way to hide any of it anyway? Thanks [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

Hi Guys! I want to hide the source of my page, so that when the visitor selects View --> Source, nothing shows. Is there a way to do that? Thanks! [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

I have the same problem. Any help will be greatly appreciated! [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

Thanks, luceze! But isn't there a built-in function to do this??? [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

Hi Guys!!! I need to translate a date. For example, if my user enters 08/20/2004, I need it to read 20 de agosto de 2004, instead of August 20, 2004, WITHOUT me having to change the system settings. Does anyone knows how to do this, without entering into a long, long SELECT --> CASE routine...

Hi Guys! I finally solved it! I posted the solution in a FAQ (faq401-5291) I did as DoubleD suggested using the instructions found in this Cognos document. Now, as you know I have 2 datasources in the model. For some reason, it's duplicating the amount of telephone_numbers, although the...

Guys! Sorry to inform you, none of the things I did worked.... I went to Cognos Support and found some information regarding this issue: http://support.cognos.com/kb-app/knowledgebase?document_search_show_document=1&document_id=112763&version_id=4 I'm working on it right now. I'll keep...

Thanks, guys! This is what my cube should look like when I filter by the measure of ALL TELEPHONES. -------------------------------------- Active | Inactive | Total | -------------------------------------- Fixed | 4 | 1 | 5 |...

Hi lex! Actually, the Customer_id does appear more than once, since one customer can have several tel_numbers attached to it. On the other hand, the model does not include a dimension for customer_id, since it's built to consider only the amount of active/inactive telephone lines (I'm just...