cancel
Showing results for 
Search instead for 
Did you mean: 

About objects mapping

Former Member
0 Kudos

Hello community!

Using IDT 14.0.4.

I have two similar dimensional tables (T1 and T2) with columns named COL_1. I want to map 'dimension' object to both this tables and make BO build query on one of them, dependant on selected context (Multi SQL is checked for both contexts and measures). Is it possible?

I've tried to create object with sql='COL_1' and selected both T1 and T2 in 'Extra Tables' property, but it throws an error (WIS 00008)

What I'm doing wrong and is it possible at all?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

abkshatriya
Active Participant
0 Kudos

Hi Kirill,

Can you please let me know the Use of these two Same Columns?

1-You want Table Swapping based on User Authentication?

Context Path:

Suppose if you have 3 Class: Manager, Employee and Salary

and all are coming from three Diff. tables and both dimension table are having Same Column " Name".

if you will Use context path then you will create only one Object "Name" and when NAME object is selected from Class Manager or Employee then it will ask for Context Path..

Or you can Create Name Object from Employee table and place it in Employee class and create name object from Manager Table and place it in Manager Class.

Now you wont get any Context.

Thanks