Oracle Fusion #26: Selection Steps in OTBI Part-1 (Select Member on Attributes)

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 ต.ค. 2024
  • -- Oracle Fusion Video Series : Video 26
    #SQL
    #PLSQL
    #Oracle
    #ORACLEAPPS
    #OracelFusion
    #TechTalkswithNaresh
    #Naresh
    #R12
    #EBSConsultant
    Join Our Telegram Group:
    t.me/techtalks...
    FOLLOW US :
    ============
    TH-cam : / techtalkwithnaresh
    For More details Contact Us:
    Email: nareshtech21@gmail.com
    -------------------------------------------------------------------------------------------------------------------------------------------------------------
    In this Playlist I had uploaded all the videos which help you to learn the Oracle Fusion BI Reports and Oracle Fusion OTBI Reports which will help you to improve your skills. If you have any doubt's regarding any of the uploaded videos you can write in comment section. If you need more videos on other topics or training in Oracle fusion you can reach out me at nareshtech21@gmail.com. Please do like, share and Subscribe the channel to get latest videos.
    ---------------------------------------------------------------------------------------------------------------------------
    Selection steps: Selection steps are same as filter, but filters can apply on measure and Attribute only. Selection steps are applied on attribute and hierarchical columns.
    1. Subject Area have 3 columns.
    A. Attributes: Columns with Alpha numeric date data called as Attributes column.
    B. Measures: Column with numeric data called as Measures column.
    C. Hierarchical: Column with Hierarchy data called as Hierarchical column.
    2. Create Analysis (OTBI Report) with below columns & create compound layout, bar chart & gauge. List of columns Business_Unit, Supplier_Type, Supplier, Invoice_Amount, Invoice_Amount_Paid, Discount_Token.
    3. Add the condition for not null columns.
    4. Section Steps at attribute level, following operation we have to performed:
    A. Select Members. B. Add Groups or calculated items. C. Apply Condition.

ความคิดเห็น • 10