TM1 Forum

Hi, @BariAbdul: Yes, I am trying to copy from one measure to another within the same cube ABC based on Dates. Please find the attached variables screenshot and below Prolog Code for reference: @Wim: I will check as per your suggestion ##### Destroy the View and Subsets if exists ##### ViewDestroy('A...

Some more information:

TI Process running without any issues, the only problem data is not loading properly.

Any pointers would be really helpful to me.

Regards,
Sathish

Hi, Below is the code i trying to load the data into Cube using TI and Cube view. Steps followed: 1) Data source as Cube View 2) Created a cube view with all zero level dims(Dynamically - Prolog) 3) Data tab i have wrote below code to copy/load 4) CellgetN is using to get next week data and and Cell...

Thanks declanr and Jim !!!

The below code working fine and exactly fitted for my requirement.

Really really thanks for help.

Regards,
Sathish

Hi Jim,

Can you please shed light on the below..as my datasource is CSV File.
Use a subset as the datasource containing each product so the while loop applies to every child.

Regards,
Sathish

Hi Jim, Thanks for reply.. Yes, We are trying with ELCOMPN, ELCOMP functions only, the concern is,one product can have multiple children. So we are trying to get the number of children of specified product and trying to loop those my times. But we are unable to achieve the same as all these should b...

Hi, I am trying to create a TI Process to load all children of consolidated source data. Requirement: My source data is at Consolidated level and i need to load the same data in cube at all children's of specified consolidated Level. Ex: Source data: Product Revenue 1001 1000 Product can have two (o...

Hi, I am trying to create dynamic subset using below MDX,but it is not working. Need suggestions on this. SubsetCreateByMDX('WaferSize_Item',ELPAR('Product_Dim','{FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Product_Dim] )}, 0)}, [Product_Dim].[SIZE] = "200")}'), 1)); Here "200" is...

Thanks alot Declanr!!

After setting the "allow different rules for N and C levels = T" property in cfg file, the "ConsolidatedMin" working fine for rules derived cells also.

Regards,
Sathish

Hi Declan, Thanks for reply. I tried the consolidatedMin with simple rules and by changing the order of the rules. Still consolidated min is not working for rule derived cells and it is working fine for TI loaded cells. Please find below rules and cube trace calculation attached screen shot . In the...

Hi, Please find below are my rules and attached screen shot. I have two measures, one of which(WPD) rule derived and trying to achieve "ConsolidatedMin" at conslidation. Other one i am loading through TI Process and using "ConsolidatedMin" , then its working fine. Only Rule deriv...

Hi, We are looking for TM1 10.2 known issues and precautions like Fixpacks if any for EXCEL 2010 and EXCEL 2013. Currently we are using TM1 9.5.2 and Excel 2010, so we are planning to upgrade TM1 9.5.2 to TM1 10.2 with Excel 2010. After some time, we are planning to upgrade Office suit to 2013. Any ...

Hi All I am using "ConsolidatedMin" function to achieve the min value at consolidation,but it is not working for rule derived cells. Please find attached screen shot for reference. I tried with feeder also but no luck. Is there any thing i am missed out. Please help me on this. Regards, Sa...

Hi All, We are planning to migrate our TM1 9.5.2 with Excel 2010 to TM1 10.2 with Excel 2010 and excel 2013. Can you please share the experiences of compatibility of TM1 10.2 with Excel 2010 and excel 2013. It would be very helpful to us if you share known issues faced/Precautions need to take while...

Hi All,

We trying to achieve to get the Max value at consolidation based on product elements instead of TM1 sum.

We have other dimensions as well in original cube.

Please find below sample screen for reference.

Any help/Suggestions are much appreciated.


Regards,
Sathish

Hi,

Thanks for reply.
We tried with Subnm(),Dimix functions,but there are not working the way we are looking for.

Please find the attached screen shot for reference.

Regards,
Sathish

Hi,

We are trying to show the Dimension elements into excel cell drop down list of values.
Is any function that calls the dimension elements into excel.
Please help me on this.

Please Let me know if you need more details.


Regards.
Sathish

Hi All, We are trying to remove the users who are not active for last 6 months. Is it possilbe to find the last date of a client logged in to TM1? We are using LDAP single-sign-on mechanism for authentication. Any suggestions/help really appreciated to fulfill this. We are using TM1 9.5.2 on windows...

Hi Tomok, We have same number of dims,subsets and cubes in both environments(dev and tst). Here the issue is: we are trying to test the report in dev environment without migrating to test environment. Before starting our work we changed all the references of the dev Active form to test,but we are no...

Hi,

We unknowly duplicated the post.Sorry for duplicating.
In future,we will not repeat the same.
sorry for the inconvenience caused.

Regards,
Sathish