Can any please explain FOR EACH AND FOR ALL?
Answer Posted / nameer
For Each :
Used to add the dimension to the calculation context.
eg: sum([sales_revenue] For Each ([quarter])) IN ([year])
For All :
Used to remove the dimension from the calculation context.
eg: sum([sales_revenue] For All ([quarter])) IN ([year])
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain difference between zabo and webi?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What is top business?
What is aggregate table and aggregate fact table ... Any examples of both?
What three things do you consider to be the most important factors for a manager?
Can we configure two instances of CMS pointing to two different CMS system databases?
Can Bo generates the Report from the cubical data Explain?
Did you face any problems while creating reports? Name? Solutions?
What is the difference between slice and dice and cross tab report?
What Is The Difference Between Oltp And Olap?
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...
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain what is the difference between business requirement document and use case document.