Recent content by Rolldice

Hey Cognos communitiy.. I know someone must be trying to surpress those NULLS from showing in there hierarchies in Analysis Studio.. I'm pretty stuck on this one.. Any ideas???? ---------------------------------------- Another throw closer to a win ... ...

Hello, I have a ragged hier going modelled in FM and published out to Analysis Studio. I would like to excluded the NULL fields Rather than use a custom set??? Any help welcome. ---------------------------------------- Another throw closer to a win ... ...

Sub-Administrators should see only the users which he create in oid ---------------------------------------- Another throw closer to a win ... ??? ----------------------------------------

Hello, To close this thread I wanted to say thanks - We weren't able to change the versions of transformer for various reasons. However one point of interest to anyone following this is that the use of multiple datasources allows a complete picture of the entire dimensions data (Even if it...

Stefan, Thanks for all your help. We got both external linking working (Accman to OID) and SSO up as well. Your e-mails put us in the right direction Thanks ---------------------------------------- Another throw closer to a win ... ??? ----------------------------------------

Stefan, For "External User Linking" do I have to set this up on the UNIX box ccs file OR can I do this using Access Manager on my windows PC through the GUI? Regards ---------------------------------------- Another throw closer to a win ... ??? ----------------------------------------

Thanks drlex, we're on 7.3 - I'll push for the upgrade and give you a star if we get those performance improvements!! Cheers ---------------------------------------- Another throw closer to a win ... ??? ----------------------------------------

Thanks Moonbaby and Billnted! Billnted I took your advice and built two models one with multiple data sources and the other with one data source. The build times were surprising. - Multiple data sources took 1 hour 20 minutes to build - Single data source model took 1 hour. I expected the...

Thanks Stefan, I'll work on true linking - That's def. what we are after. We also want SSO between an Oracle app. using Oracle portal and Cognos 8 that's why we have included the other namespace from OID. If we have true linking established between OID and SunOne, with only the "Cognos Series...

Stefan, Yes 10G is LDAP 3.0 compliant. Cognos 8 is reading from both namespaces no prob's. When you say 'Link' do I take it that the same true user is in both LDAP's (Sun and OID) i.e. manually entered in each? I understand the rest, I think I was getting confused with the external linking...

Stefan, Sorry for the delay. The only documentataion I could find on linking external users was using Access Manager, right clicking the users folder and link Users. However this would require us to link to Active Dirrectory wouldn't it?? At this point we are looking at importing users...

Hello Cognos friends, Can anybody tell me if it's possible to use the SDK or some other method to apply security to powercubes? Is Access Manager the only way to get user security in the MDL?? We are trying to avoid the administration or having 2 directory servers. The other LDAP is Oracles...

Thanks - I'm going to test both : ) But I was just wondering what best practice is.. I'm stuck in a political debate. I'll let you know the results when i run both models with a large fact table. Going from experience I found that more data sources took longer and created a larger cube...

Hello all, This is a best practice question. Is it better to have dimensions coming into transformer as single data sources i.e 3 dimensions - 3 datasources plus the fact table, which then combine during build time. Or is it better to have a single data source coming from a star schema, with...

Done it again. I restarted all the services and this corrected the problem.. opps! ---------------------------------------- Another throw closer to a win ... ??? ----------------------------------------