A dimension tables plays a critical role in data warehousing and has strong association with facts of the business process. It consists of descriptive attributes typically text fields which describe facts but are complete and have discreet values. Facts are the metrics that business houses use for making decisions. Dimensions are generally descriptions Read more
You can schedule reports based on events. There are three (3) different types of events:
– Schedule Read more
Relational database problem where join path returns more data than expected. A Fan Trap occurs in one – many – many relationship and Chasm trap occurs in many – one relationship.
A fan trap is a less common problem than chasm traps but has the same effect of returning more data than expected. Read more
How many Fridays are in each month?
To answer this query you use grouping and counting:
day_date_month, Read more
Return all leap years:
The SQL for this is straightforward: Read more
Calculation Contexts gives more control over how a formula or measure is evaluated. let’s take an example, a report could show sales revenue (measure) by year (dimension), where revenue is dependend on year(dimension). Read more
Display summary Information (SUM) not the detail (table) on business object desktop Reporting – Deski
1. Insert a break on the column of your choice.
2. Right click and select Format break
3. Select “Fold” option (checkbox)
and this will do the magic.
Data warehouse is mutidimensional data structure where Dimention is a category of information. For example, “Customer”, “Date”, and “Product” are all dimensions that could be applied meaningfully to a sales receipt. The primary function of dimensions is to filter, group and label. Read more
Just came across awsome article written by Dave Rathbun for the beginner and especially if they come from a spreadsheet background where everything is right up in front. Read more
I broke report in multiple sections. ex:
Account 001 $100.00
Account 001 $120.00
Account 003 $100.00
Account 930 $53.09
Account 001 $50.00
Account 043 $34.09
Account 930 $454.98
How can i add a column which will give me total sum based on Account number. Ex: I need total count of Account 001. Should be $270.00
Account 001 $100.00 $270.00
Account 001 $120.00 $270.00
Account 003 $100.00 $100.00
Account 930 $57.00 $500.00
Account 001 $50.00 $270.00
Account 043 $34.09 $34.09
Account 930 $443.00 $500.00
Answer: FOR EACH … IN REPORTS .
EX: =CountAll(<Account Name>) ForEach <Account Number> In Report