Hello, The format for the DATEREFENCE field is DATE (in the Oracle schema and in the physical layer of the SM). In the workbook in the dashboard filter the format in set to Auto (dd/MM/YYYY) and the field is recognized as Date as you see below. I don't understand the error related to the time series (AGO function or…

@Sarahi Romero-Oracle Yes, with Analytics Link option like @Matt Milella-Oracle said. As you see you cannot invoke directly the 'New Data Action' action that you created from your 'Home' textbox. But you can invoke a published canvas like 'Last 6 Period Analysis' because it is in the list, so it's not a problem. Daniel

Hello Matt, I'm using Chome, I already put "backgroundColor": "#227E9E", "textColor": "white" in the json text, the white rectangles in the picture (on the buttons) appears only for 1 second just after the page reload then disappears Personnaly I use the normal tabs (bottom) to change canvas in an existing workbook. I…

Hello, Yes it's just a start to a full navigation viz. I just tested the extension and I have some observations: the switch it's not smooth, I have the message with the joke between transition, then 'Click to Edit Mode' after (I used "sameWindow": true) a white background appears on the buttons (image bellow) if I like to…

Happy for this one. I will try to use that extension. For moment I use simple text boxes (on top) to change the canvas and the standard OAC navigation (on bottom). Have a good day!

Hello, Like I said I already have the 2 mesures and I want to use mostly Horizontal Bar Graphs and Pie Graphs. In the image bellow I want to keep only the left side graph that is filtered by region ans territory (in blue rectangle). It's the only dynamic graph (when I modify the filter) The other graph (in red) is static…

Hello @Mostafa Morsy-Oracle and @SteveF-Oracle Can you explain me how I display the red percents(National) near the grey percents (Regional) on the same graph like in my picture using overlay chart or horizontal 100% stacked bar chart? For my case I use mosly Pie charts et Horizonal Bar charts. Supposing that I have 2…

Hello, Thanks @Federico Venturin and @Gianni Ceresa for your answers. Of course there is a cleaner model based on PERSON_ID | QUESTION_ID | ANSWER fields. I wasn't very accurate on the quiz. I have finally one single question with 10 possibles and combined answers (no 8-9 like as I said). So the table has 3500 lines (one…

Hello, BIG drawback in my model for the question bellow. Q3: The orders total amount (F_COMANDES) by item type (D_ITEM)? The first two items (Article 1 et Article 2 have both the type 1) et Article 3 of type 2. The both calculations are false in this case (in red). The quantity field (Cantite) is good. Because each command…

Hello, As you can see in the semantic model capture (from the logical layer) the 2 calculations point to the same table column in the master table (F_COMANDES). The agregation is Sum for the both. I have 2 fact tables in my logical layer: 1.Master table Fait-commande with LTS: A_COMMANDES and the calculation 'Total…

Hi, Thanks @Gianni Ceresa for you help. I didn't saw that 'Sort by' field in columns details :) It's working now, so I used this sorting principle for 'month name' and 'day of the week name'. I also switch back the time hierarchy type (Time ⇒ Level based) to keep it simple (cause no time series)

Hello, So I made a Time dimension with a Time hierarchy (not a Level-based hierarchy) only for having 'Cronological Key' field there and try to make a default filter on month index (1-12) and not to the month name. I don't use time series on things like that, so for me a level-based hierarchy would have been more then…

Thanks @Gianni Ceresa for the explanation. Effectivelly I will try in this case to join that flat Datetime column (DOCUMENT_DATE_CREATION) to a proper Time dimension (and create a hierarchy like Year, Quarter, Month, Day etc on that dimension) Daniel

Hello, Of course, I activated the 'Preview Excel Export' as an administrator and only once. It's still activated for all the users. Then I connect as a normal user or admin doesn't matter. The first time I don't see the excel format in Export workbook. Daniel

Hi, Thanks, @GayathriAnand-Oracle for the explanation. Best regards, Daniel

Hello, If there is a fix for that please let me know. I must do something? We didn't create a SR for this problem yet. Yes @Gianni Ceresa I'm aware that I'm not the only person that have the same issue. Thanks, Daniel

Hello, yes @Avinash Krishnaram-Oracle it's exactly this. I made a simple test workbook in english to show the problem in a simple visual way. In fact the region selected is a part of France that contains 1-2 territories and each territory some departements like bellow. But it not very important this, the…

I revisit the workbook of course in viewer mode, not in edit mode. I see well the saved daskboard filter(on that region) but on the 2 tiles the values are equals (men and women) and it's represents the total for that region(for men and women) When I click the button to reinitialize the workbook to the original version the…

Sorry, I was too fast... In fact it's a filter problem on a particular dimension and not a Map view problem

Hello, I create the SR 3-34540243571 related to Usage Tracking in My Oracle Support and I put some error logs there. Khader Belgoud(d'Oracle) send me the logs when we tried to find some problems related to filter latency (on another SR). I don't know if I can find myself these backend logs in OAC console. He advised me to…