That's right, @Gianni Ceresa, it's not as obvious. I tried it so many different ways and got either no data at all, or fresh new exciting errors so many times! Ultimately, here's how I solved the problem: In the Logical Table Source for my suppliers dimension, I get most of my fields from a physical table (a view,…

Thank you for responding, @Gianni Ceresa! So far, I have been trying to do this with my contracts table defined as a Dimension table. Not all suppliers will have contracts, but a supplier having multiple contracts would be fairly common. I should mention here that I have no interest in the contract data itself - merely the…

@User_Q7SHC , there is an AGGREGATE function available in OAC; you can insert it into a formula … although it may adversely affect your analysis's performance. In my particular situation, as you can see from the screenshots in my post above, I was breaking down vertically (Y-axis) by a six-digit account. The values across…

Thank you for responding so quickly, @Gianni Ceresa! This is going to sound unnecessarily convoluted, but it's my own fault. I did it to myself. The reason the "normal" filters weren't working, regardless of how I grouped them and whether I used AND or OR was because I was summing up groups of records that had no values…

This reminds me of something that I encountered a few months ago: in Oracle Analytics Cloud, the Writeback Template XML is part of the System Settings in the console, and you no longer need to click a button for changes made to the template to take effect - simply moving one's cursor outside the box prompts OAC to save the…

Thanks again, @Gianni Ceresa. I want to convey my most heartfelt appreciation for the attention and advice you've provided. This was really a frustrating problem for me, especially given the data model's simplicity! After removing the content levels from my three measures and preparing to take a series of screenshots to…

@Gianni Ceresa, I tried modifying a few pieces of the Semantic Model for the Measures (there's a screenshot of that further down), and now I get sub-totals in the hierarchy… but they are incorrect. What's more, as I open and close parts of the hierarchy on the Results tab, the values change! As you can see in this first…

Thank you for responding so quickly, @Gianni Ceresa! I suspected there might be something more I could do in my Semantic Model, but I'm not sure what. I'm having difficulty finding relevant documentation and examples that are specific to OAC as opposed to products like OAS or OBIEE. The hierarchy looked fine, and when I…