Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Rolldice
  • Content: Threads
  • Order by date
  1. Rolldice

    Surpress Null's in hierarchy AS

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

    2 LDAP's and Series 8

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

    Cube Build Times

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

    Security and Metrics Manager

    Hello all, I would like to lock down some scorecards that I have, so that only certain users, within a user class can see them. I have created the new user class, Under the Root User Class and I have Synchronized Access Manager users in the General Services Tab. When I go to the permissions...
  5. Rolldice

    CMM 2.2 and Oracle 9i - Connection issues

    Hello all, I've been having lots of CMM configuration issues. No doubt others have been in this situation before. I managed to get CMM up and running on a distributed environment - Connecting to a MSSQL Server backend. However we have had to change to Oracle. After the database build I...
  6. Rolldice

    Transformer Migration from NT to Unix

    Hello, Can I open an NT model in transformer for UNIX and it in that version. Or do I have to rebuild this from scratch?? Cheers ---------------------------------------- Another throw closer to a win ... ??? ----------------------------------------
  7. Rolldice

    Comparing Relative Time Periods

    Hello Cognos Colleagues, I have a time dimension with a Fiscal Year dimension of Yr, Quarter, Month I also have another drill down of 6 month blocks called ‘Period Of Activity’ POA. During a given year POA1 and POA2. What I would like to do is to compare POA2 with POA1 within the same year –...
  8. Rolldice

    Showing Special Categories - Rollups and non Rollups

    Hello all, I have a organisation structure that has an inconsistence Rollup of sales figures between the various levels in the organisations hierarchy. To accommodate this I have used special categories. I have allowed some special categories to rollup up to their parents and others not to...
  9. Rolldice

    TR1901 - Base measure for category count cannot be calulated

    Hello all, I am building a CRM cube which merges 4 fact tables together (I know this isn't the best idea). But the client wants all the metrics in one cube and some of the measures are calulated across the differant CRM activity fact tables. So I have come up with a cube which was working...
  10. Rolldice

    Oracle loader ERROR - using external table

    hello, I'm using an external table to load data into my database. I was getting an error of: data to big for data type, which came from blank space in my last source field. After looking up a thread on this I found a solution to Trim that incoming field - But I can't seem to get the sintax...
  11. Rolldice

    Oracle Listener

    Hello, (I'm VERY new to Linux) I can't get a response from the: lsnrctl status command or: lsnrctl start I get the following error: lsnrctl: lsnrctl: cannot execute binary file Where am I doing wrong? I'm logged in as Oracle. ls - l listener.ora: -rw-rw-r-- 1 oracle dba I really want...
  12. Rolldice

    Can't PATH Variable in Linux

    OK - having never looked at linux before this week I'm in the dark here: AND I really can't see. I'm trying to start an Oracle 9i database up on Linux We are running Red Hat: Linux Advanced Server on an IBM x series box. I have followed instructions by O'Reilly Network, and successfully loaded...

Part and Inventory Search

Back
Top