Welcome to the Oracle Analytics Community

Home› Luigi_Gif› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Luigi_Gif Rank 3 - Community Apprentice

Comments

  • Thanks Gianni
    in Zipped copy of catalog in OBIEE Comment by Luigi_Gif Dec 11, 2017 12:40PM
  • Thank you Rober, I've studied the instruction in the link, now I start working on my DWH and I will bring you up as sonn as I have new Luigi
    in Ago function Comment by Luigi_Gif Nov 3, 2017 10:02AM
  • Hi Robert, I moved as you asked me, below I show that WEEK in the database is well linked to, but it is not a unique key as it seems: To do it I think I should go on my Physical model, AL_PERIOD_SCH_SHIP_DATE, click on properties, and in the section Key I add a new one; that is week...right ? Now is as showed below: I…
    in Ago function Comment by Luigi_Gif Nov 3, 2017 7:00AM
  • Hi Rober, Ok now, I'm sorry but I have been enjoying BI for 7 days. Below I attached the schema requested I hope it will be ok for you to understand my problem: In the physical column on the right I also opened the period variable used in my report Thanks a lot Luigi
    in Ago function Comment by Luigi_Gif Nov 3, 2017 6:23AM
  • Hi Robert, Here below I attach my time dimension hierarchy The Key in this case is DAY, like in all others time dimensions. In my report if I use AGO function and I use the month as a filter, It will work, when I use week it will not
    in Ago function Comment by Luigi_Gif Nov 2, 2017 10:42AM
  • Dear Christian, I have never seen a funny RPD ahah, I am a Deloitte consulting and now I am trying to drive a costumer of ours in his BI activity. So they contact me when there is a problem, this RPD was build by them...
    in Ago function Comment by Luigi_Gif Oct 30, 2017 10:13AM
  • I set my time dimension as displeyed
    in Ago function Comment by Luigi_Gif Oct 30, 2017 9:58AM
  • Hi Joel, Oracle Business Intelligence Product Version 11.1.1.9.160719 while the error is: Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message…
    in Ago function Comment by Luigi_Gif Oct 30, 2017 9:54AM
  • Ok Gianni, thanks a lot for your help; now it seems working. I am sorry but it's my third day on oracle BI . A last dubt... I want to insert TODATE function into "Actual" column (the 6th from the left of my picture) that has a formula such as: FILTER("Sale Amount"."Order" USING ("Scenario"."Scenario" = 'Actual' AND…
    in Year To Date measure Comment by Luigi_Gif Oct 22, 2017 2:26PM
  • Hi Gianni, Your answer is correct, because...reading different forum I just found TODATE function as my problem solving. However, the problem is...it seems TODATE function works only if you set a time dimension, in fact if I write TODATE ("Sale Amount"."Actual", "Market Period"."Year") the code doesn't work
    in Year To Date measure Comment by Luigi_Gif Oct 22, 2017 1:36PM