Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Ramamohan Reddy · 2018-11-03 06:51:54

Hi All, I have a fact table for Sale_Amt with date wise details. It is designed with self-join. One of my reporting requirement is to show yesterday (sysdate-1), MTD (1st Nov to till date) and YTD sales (1st Apr 2018 to till date -- a Financial year) Fact table data:- Date item1 Sales item2 sales 01-Nov-2018 100 200…

How to get YTD sale for the Financial year ( 1st Apr 2018 to 31st Mar 2019) In OBIEE 11g

Received Response

162

Views

Comments

Answers

[Deleted User] Rank 2 - Community Beginner

Mar 22, 2022 2:20PM

https://community.oracle.com/tech/apps-infra/discussion/comment/16829865#Comment_16829865

As stated above: start a new thread explaining the whole context.

This thread is old, answered and it hasn't been opened by your.

0

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

How to get YTD sale for the Financial year ( 1st Apr 2018 to 31st Mar 2019) In OBIEE 11g

Answers