on 2016 Feb 18 7:54 AM
Dear All,
what are dimension types can be used as reference dimensions ?
time, entity, group, subtables
Request clarification before answering.
Hello Merwin,
Do you mean reference dimensions as Referential integrity then go through this,...
Dimension Type | Reference Type | Property Name | Reference Attribute Name |
A — ACCOUNT | R_ ACCOUNT | RATETYPE | ID |
C — CATEGORY | TIME | YEAR | YEAR |
E — ENTITY | INPUT CURRENCY | CURRENCY | ID |
I — INTERCOMPANY | R_ ENTITY | ENTITY | ID |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Group and Time
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What do you mean by "reference dimensions"?
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jayapradap,
There is some thing wrong in Ravi answered,Inter company never reference with R_Entity,
The main concept reference dimension it first validates the properties of the reference dimension with the dimension member, then it validate the master dimension, When you validate the dimension it's check system the values of the Referential Integrity property.
Khokan
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.