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 Mike Lewis 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: *

  1. nphani77

    Problem While Taking Ratio's of Measures from Two Fact Tables

    Hi, I have got three tables like two Fact tables and one confirmed time dimension.I need to take the ratio of two facts existing in each of the fact tables and aggregate them at month level.When I try to achive this I am getting the wrong results basically because of the cartesian product.I know...
  2. nphani77

    French Language support -Analyzer

    Hi, I Have installed Hyperion and my essbase is supporting Frech language.But when I created a report in Analyzer its not supporting frech language so I am getting boxes inplace of french letters. What setting should I do so that Analyzer supports french also. Quick response would be appriciated...
  3. nphani77

    Hi, I want to calculate diff

    Ok I got it... Thanks Phani
  4. nphani77

    Hi, I want to calculate diff

    Hi Just add to my previous mail...the project end date i would be passing through the prompt. So database cannot understand the statements like @variable or @ prompt functions.So BO is unable to parse it. So i cannot save that object without parsing.How can I achieve this
  5. nphani77

    Hi, I want to calculate diff

    Hi, I want to calculate difference of 2 dates at universe level and store the result universe objects. Example: Consider that my database consists of Project Table, which contains ProjectID , Startdate, Enddate. I want to Calculate the difference between Project start date and Project end...
  6. nphani77

    How to create a Cascading prompt

    Thank you Steve.. I have tested it...Its working fine. Thanks once agin Regards, phani
  7. nphani77

    How to create a Cascading prompt

    Hi, How to create a Cascading prompt--> i.e suppose if i have one hierarchy called time. Year quarter month week. The prompt should come in such a manner that first it should ask for year and once year is selected it should ask for quarters in that year only and once Quarter is selected it...
  8. nphani77

    Updation of Fact table

    Hi, How to Update a big fact table having 13 dimensions and Millions of rows using informatica with optimum Performance? One thing i was pondering upon is that is it a good practise to use a fact table as Lookup table? Please answer this ASAP

Part and Inventory Search

Back
Top