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...
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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.