Dear All:
I have the poc for manufacture,the customer have the idea about the drill though action,below is the step
1.Open the bom structure view,the user ant to change the one of material vender,
2. when the user click the material ,so the tm1 must open the cube view(from the vender cube),the vender view only can show
the info whih connect form the material code that user click.
3.After the user decide which vender be choice then the vender's material price must feed back to bom structure.
so my question how to get the value fom the user,because i can't receive the value from the user ,because he can decide which the material he want to change the vender.
peter
How get the value from the user
-
peterchang29_TM1
- Posts: 2
- Joined: Thu Aug 04, 2011 3:26 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
-
paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: How get the value from the user
Peter
You have Cube A which has Dimension Material
You have Cube B which has Dimensions Material & Vendor
The user will right click on Cube A alongside his selected Material, and select a Drill Thru option that you need to define via Drill Rules. The option will be a TI Drill Process that you also need to define. The TI Drill Process can then return a View which will have the Material selected in Cube A as a Page By dimension, and the rows will have the Vendors. You will need to make the View Zero Suppress on the Rows. On the columns you can show measures, for, eg Past Sales. Therefore only vendors who have made past sales of the Material will show up in the Zero Suppressed View. If you want to show vendors who haven't yet sold the Material, then zero-suppress on another measure, eg best price offered, etc.
Regards
Paul Simon
You have Cube A which has Dimension Material
You have Cube B which has Dimensions Material & Vendor
The user will right click on Cube A alongside his selected Material, and select a Drill Thru option that you need to define via Drill Rules. The option will be a TI Drill Process that you also need to define. The TI Drill Process can then return a View which will have the Material selected in Cube A as a Page By dimension, and the rows will have the Vendors. You will need to make the View Zero Suppress on the Rows. On the columns you can show measures, for, eg Past Sales. Therefore only vendors who have made past sales of the Material will show up in the Zero Suppressed View. If you want to show vendors who haven't yet sold the Material, then zero-suppress on another measure, eg best price offered, etc.
Regards
Paul Simon