Welcome to the Oracle Analytics Community

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

Matthias_VC Rank 3 - Community Apprentice

Comments

  • Okay finally, Mission accomplished! Thank you Jerry, for helping me go through this. Otherwise I would have undoubtably given up!
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Wait, found the answer online. I've had to put "Aggregation Rule" to None... Hmmm now start over and just add month...
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Okay, Filtering helped in trying to create a pivotTable. I was able to get the following result: With following SQL query: SELECT saw_0, saw_1, saw_2, saw_3, saw_4, COUNT(DISTINCT saw_2 by saw_0, saw_1, saw_4) saw_5 FROM ( (SELECT "General - (Project)"."Project Object Id" saw_0, "General - (Project)"."Project Name" saw_1,…
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Okay, I think I'm in an older version as my layout is slightly different. However if I add a Pivot Table it gives me the same error as before And the problem is: once you have an error you can't change the visual or anything. So I'm wondering if this is a Catch-22 situation, or in which order I should execute it to get the…
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Hmmm okay, adding a by statement solves that error. I now have something: But this give me way too many lines to add in a graph of any sort. If I try to start creating a line chart for instance it gives me this error. So obviously I should remove one column from the table (Activity ID). However if I remove it in the table…
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • OK, ok thanks so much, quite clear and you've helped me a lot in understanding. I'm nearly there, I guess. I've had another error on the way: => Set operation failed due to incompatible sort order. But this has been resolved by using a 'Union All' instead of a normal Union. But now I've got this one after adding a Count…
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Yes, You're right! Can it also be a case of having the correct permissions (if so I just have to file a service request). Otherwise I'll try to see if I can recreate the SQL Myself. Will it impose the same restrictions as the visual way I tried before? As in: is it ever possible to do a COUNT DISTINCT before the union? If…
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Hey Jerry I tried your approach, as it was the most visual. This was a promising course, put some hours into it (which is why it took >1 day to reply), however I couldn't get it to work. First time I tried it I got the error: "The data view layout builder was unable to create the proper grid view layout. The logical column…
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Is this always possible? If I go to New-> Analysis I only have the availability to select from existing Models. If I go to New-> Dataset I do have the option to create a new SQL Query. but this one I can only access in reports, not in analyses, right?
    in Analysis measure based on external filter Comment by Matthias_VC December 2019
  • Okay, Thank you very much! I'm a bit unsure whos answer I should mark as "the correct one" because now I have two viable ways of making it work! I was able to do edit my previous filter this way. When in SQL edit mode, I saw that the apostrophes were not in the formula where I placed them in the calculated column. So I…
    in Save other field than Prompted as presentation variable Comment by Matthias_VC December 2019