TM1 Forum

ardi wrote:Try this:

Code: Select all

{TM1SORT( UNION(
{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Transaction ID] )}, 0)},
{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Transaction ID] )}, 0)},ALL
) , ASC)}

Worked. Thanks a lot

I have a requirement where each element of my MDX subset is supposed to appear twice to be used on an Active Form(Basically duplicate all elements). Easiest way I could think of was to do an UNION ALL with the same MDX query. So I wrote the following MDX: UNION( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Tr...

declanr wrote:

PavoGa wrote:

• using = N: notation
  converting the value to be stored to a string
  ['Director_Subset_Flag'] = 99;
  ['Director_Subset_Flag'] = N:99;

Try:

Code: Select all

['Director_Subset_Flag']=S: '99';

This worked. Thanks. Really odd though.. Drove me crazy initially

ViRa,

I have 2 questions:
1. So a vendor can choose more than one Model, Risk type for each account?
2. What exactly are you doing in Cube A before ASCIIOUTPUT. Are there some rules which cannot be applied directly on Cube B?

When I tried creating new chores one for each process separately, they works fine. Also, I created one more new chore and added two process in same order and saved with same parameter as original chore. To my surprise, new chore got saved and activated and still old chore is giving same error after...

Have you tried turning the PersistantFeeders back on? to verify whether that was the actual cause.

Also, when you say buffering I assume its just kinda 'stuck' with a loading animation. Have you tried leaving it alone for sometime. See if that generates any specific Error code?

Would be nice to see the last updated lines of your message log. Where exactly are they 'stuck'?

Most of the time these kinds of issues are due to presence of Space in a filepath and any improper usage of double quotes. Can you post the output you got from ASCIIOUTPUT? One more thing you can try is.. probably see if you can print the arguments from the vb script to check if they are received co...

As mentioned above, please go through Developer guides or IBM training. You could learn writing code for your scenario by going through this specific topic here: http://www.ibm.com/support/knowledgecenter/SS9RXT_9.5.0/com.ibm.swg.im.cognos.tm1_rul.9.5.2.doc/tm1_rul_id2473ExchangeRateCalculationUsing...

HI Gtonkin, Thanks for replying.. I've tried your recommendation and it still doesn't work.. I've also created another web sheet from scratch and it doesn't work.. Just to complicate the issue, I have replicated the multiple filters on another instance based on a different cube and it works.... :| ...

Hello, We have been running Windows 10, using MS Edge, for some weeks now and TM1 Web 10.2.2 FP3 is working faster than ever before. Only one issue we have encountered with MS Edge yet, TM1 does not allow to paste things in our out from the Edge browser. Pop up sazs: "Copying to clipboard is c...

That sounds like a good solution. Thanks for sharing. However, the users are expecting a fancy yet simple interface with couple of check boxes to make their selections. Hence, the front-end piece came into picture. Anyway, in my case multiple users could be making their choices at a time. Wouldn't ...

Curious. I just tested it out. Had a test cube created with 2 dimensions (Dummy_Acct, Dummy_Amount). First entered an amount of 25000 for all accounts. Through a rule, assigned 500 to one specific account. Using a TI, I took the cube as source and used below: ViewExtractSkipCalcsSet ViewExtractSkipR...

Karthik, From a front-end application, the users will choose the Account, Model, Type and Time for which they need the details (Cube A is the detailed cube). These choices which will be stored in the back-end (SQL) will be used to update Cube B. Thus, Cube B now stores these choices (as measures) a...

I am not sure if I understand your requirement completely. Cube B (cube stores the choices of Account, Model, Type and Time made by the users through a front-end). These details in Cube B(Account, Model, Type and Time) are stored as measures? What are the dimensions you have for this cube? In genera...

Don't know you have to open all these TI's. You only have to open a TI (and thus get the preview screen) whenever you need to CHANGE the process and if you are changing the process you probably want to get the preview to make sure all your variables are accounted for properly. If you do not intend ...

What about the "Use Unicode" setting in your TI process ? Is it enabled or disabled ? Also http://www.tm1forum.com/viewtopic.php?f=3&t=1668&p=8758 This might give you a pointers . Thank you, we do have some of those suggestions already implemented. I think its time I explain this ...

Thank you for all the replies people. We didn't want to waste too much time with this. Here is what we did. It's not the perfect solution but the quickest way we could think of: Built a process to export the dimensions used in dropdowns into an excel file(Dropdowns.xls) and scheduled it for everyday...

Hello All, This might sound a bit weird. But is there a way for us to disable the 'Preview' being shown automatically while opening a TI process using ODBC? Reason? Long story short, we want to avoid database account lockups. So, we don't want TM1 to try to connect to a ODBC as soon as we open the p...

Hi Everyone, I am new here. Been working on TM1 for past few months. I can use some help.. We have a requirement where User has asked us to create a slice of a cube's view. Now, I know that sounds straight forward but the tricky part is that User wants to be able to retain the picklists that we have...