Interested to Buy Any Domain ? << Click Here >> for more details...
Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?
- 2 Answers
- 31295 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan k k pottturi
MTD MEANS REPORT FROM THE STARTING DATE OF THE MONTH AND
CURRENT DATE EX:I WANT A REPORT FOR THE MTD AUGUST MEANS
The report start date must be august 1st to today date(4
aug).same for the YTD.
WHERE WE CAN USE MEANS WE CAN USE SALES AND INVENTORY ITS
DEPENDS UPON U R REQUIREMENT
| Is This Answer Correct ? | 36 Yes | 6 No |
Answer / sri
Eg for the MTD report is
select sal from emp where hiredate between
trunc(sysdate,'mm') and sysdate;
same for the ytd,qtd place yy or q respectively
| Is This Answer Correct ? | 14 Yes | 13 No |
Explain what task is 98% of the required work of a business analyst?
Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)
Can we have multiple domains?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
1. what are the differences between prompt at universe level and prompt at report level ? 2. what are the connection types in BOXI ? 3. how do we give the security in universe level ? and report level ? and objects level ? 4. what will happen if we check the 'MULTIPLE SQL STATEMENTS FOR EACH MEASURE' option in Universe SQL parameters ?
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.
How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.
5.what is LOV? where it is store?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
what is a Micro cube?
Teradata 
