Current Position:Home > RSUM and level based measure

RSUM and level based measure

Update:11-30Source: network consolidation
Advertisement
Hi all,
Is it possible to use the RSUM display function with level based measure. RSUM(LBM) in Answers.
I tried to do so but the RSUM is never correct,so i'm wondering if I'm doing something wrong or the RSUM is not working correctly with level based measures.
Regards

The Best Answer

Advertisement
What is the month level key column functionality in your time dimension?
it should be in format of yyyymm but not in just mm ..
  • RSUM and level based measure Update:11-30

    Hi all, Is it possible to use the RSUM display function with level based measure. RSUM(LBM) in Answers. I tried to do so but the RSUM is never correct,so i'm wondering if I'm doing something wrong or the RSUM is not working correctly with level based

  • Level Based Measures Update:10-11

    Hi Experts, please clarify my doubts . 1. I created 3 level based measures. Year level Revenue, Quarter level Revenue and Month level revenue. And I do have Revenue column which is not at any level. Report: I put "Date" , "Year based Revenu

  • Level Based Measure and a column based on that Update:10-11

    Hello All, I need suggestions to implement the following requirement. 1. No of orders stored in a fact table at day level 2. No. of orders at month level should be calculated 3. Depending on the count, each month would be assigned to a bucket. 0-10 o

  • Level based measure and AGO function Update:10-11

    Hi, I've a TIME fact table with a single dimension (TIME_DIM) and a single measure (WORK_DAY). WORK_DAY is 1 if the day is a working day, otherwise it is 0. This way I can get the number of working days by month, quarter and year. (TIME is a logical

  • Issue with Level-based measure at Year level Update:10-11

    Hello everyone, I am facing weird issue while using OBIEE 11g level-based measure at the Year level. I am creating a trend analysis report that are displaying Expense Accounts dimension with 6 levels and 2 measures: Expense YTD, and Expense Full Year

  • OBIEE Multiple Facts With Level Based Measures Update:11-30

    Gurus, We have a requirement which we think complex to achieve at OBIEE level. Please help if anyone knows a solid solution for this problem. Orders, Shipments and Revenue are the fact tables and we have common dimensions like customer, product, time

  • Query regarding Level Based Measure on Reports Update:11-30

    Hi All, I am facing an issue in OBIEE while using aggregate measures. Scenario My Report has the following columns. There is security applied on the report ie an Employee who logs in gets to see only his/her data. 1) Employee 2) Month 3) Monthly Sale

  • Question in Calclating Level based measure Update:11-30

    Hi all: I have a requirement, where I need to calculate a level based measure. Here is a thing though. Let me give you sample data.This is what the data in the table in database looks like company ||||account||||| product|||||subproduct||||||quantity

  • Howto create special level based measure Update:11-30

    Hi all I have a geography dimension : All -Region --coutry ---store I'm reporting the sales per year: I need to create a measure that able the user to display 'shareof sales' for every level in the hierarchy. In other words In need a logical column t

  • Issue with Level-Based Measure Calculations Update:11-30

    Hi all Edited by: aharrab_be on Jan 19, 2009 7:23 AM I've just understood the meaning of those level based measure and It's not very useful for this purpose Sorry Edited by: aharrab_be on Jan 19, 2009 7:24 AMHi, Are you using presentation hierarchy?