Versions Compared

Version Old Version 8 New Version 9
Changes made by

Dace Kvalberga

Dace Kvalberga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Align
alignjustified

Ja vēl neesat iepazinušies ar Standard-BI vispārējo pārskatu un datu analīzes un jaunu atskaišu izveidošanas funkcionalitātes aprakstiem, lūdzu iepazīstieties ar tiem. Šī instrukcija apraksta kā definēt jaunus aprēkināmos rādītājus izmantojot MDX kalkulāciju formulas.

Katra kuba dimensija sastāv no vienas vai vairākām hierarhijām ar vienu vai vairākiem hierarhijas līmeņiem. Katru hierarhijas līmeni savukārt veido dimensiju rādītāji. Eksistē normālie rādītāji, kuri ir importēti no datubāzes failiem vai aplikācijām, taču papildus tiem ir iespējams definēt arī Aprēķināmos rāditājus ( calculated members ) izmantojot kalkulāciju formulas . Kalkulāciju formulas tiek definētas izmantojot  MDX vaicājumu valodu. 

Eksistē speciāliāla dimensija Rādītāji  ( Measures ), kura satur visus ieimportētos rādītājus. Apreķināmie rāditāji visbiežak tiek definēti tieši Rādītāju dimensijā, un tie tiek saukti par Aprēķināmajiem rādītājiem.

...

Kā definēt jaunu Aprēķināmo rādītāju ?

Align
alignjustified
Ja vēlaties definēt jaunu aprēķināmo rāditāju, tad paplašiniet attiecīgo dimensiju ( piem. Measures )  un palašiniet arī Aprēķināmo rādītāju sadaļu. 

 

 

 

 

 

 

Align
alignjustified
If you would like to define new calculated member then click on Define new link, if you would like to edit (or delete) existing calculated member then click on edit link. If you do not have rights to edit calculated members in current account then you will see just show link to see definition of existing calculated members. When you define new or edit existing calculated member you will see the following calculated member definition form:

 

 

 

 

 

 

Align
alignjustified
Each calculated member should have name (unique within dimension) and calculation formula (the rest of tutorial will teach how to write calculation formulas). In addition you can specify how calculated member value should be formatted (e.g. as integer, decimal, date or using default formatting). From the right sidebar you can quickly select other members, dimensions, operators or functions to insert them in calculation formula.
After defining calculated member formula press Update to save it or Delete to delete existing calculated members or Cancel to discard any changes. If calculated member formula will be invalid then corresponding error message will be displayed.
Do not modify or delete pre-defined calculated members that were created by source application import - their original definition will be recreated next time you will perform source application import. If you need to create modified version of existing pre-defined calculated member then copy its calculation formula and create new calculated member with different name and modify copied calculation formula for the new calculated member.
Let's start writing some calculation formulas! Following examples will use Sales demo cube dimensions and measures to illustrate creation of calculation formulas.

 

 

 

...