TM1 Forum

To add, I tried the following and while it didn't error out or anything, it also didn't produce anything:

pYear = NumberToString(CellGetN('Control Cube', 'Year', 'Current'));

Wondering if we could take this just a little bit further :) So, if the parameter, 'pYear,' is changed to "String" on the Parameters tab in the Advanced section of the TI process... What happens if 'pYear' is actually coming from let's say a "Control" cube so it's like this: pYea...

Thanks again Declanr! Awesome. It's working.

Also, thanks for pointing out the FAQ. I did not see that. However, I am going to post the link below because it has a lot of great info:

http://www.tm1forum.com/viewtopic.php?f=21&t=2441

I'm gonna push my luck here :mrgreen: No big deal if there isn't a way, but I like to make things easy for the end-user... is there a way to make the time 12 hour versus 24 hours and put either an AM or a PM after the time? Thus, it would look like this: 2014-03-03 10:33 AM Just wondering... thanks ...

Ah HA! That was the boost needed! Figured it out :) ['Workflow State Measures':'State Change Date'] = S: IF (DB('}tp_application_state}768207bb-5acf-467c-9a1c-90b10807e8cf', !Organization, 'StateChangeDate') @='', '', TIMST(((NUMBR(DB('}tp_application_state}768207bb-5acf-467c-9a1c-90b10807e8cf', !Or...

For trying to figure it out... I am going to replace the obnoxious name of the control cube with something shorter and more user friendly :) ['Workflow State Measures':'State Change Date'] = S: TIMST(((NUMBR(DB('WORKFLOW', DIMNM(TABDIM ('WORKFLOW',1),1) ,'StateChangeDate'))/86400000)+3653+(-7/24)), ...

Thanks Declanr. I am just using the code that 'failurehappening' provided and simply replacing his 'tp' info with mine. It's working okay (converting) but like you said, it's repeating the same value for all items versus looking at each one individually and converting. I am in need of a true convers...

bump

Hi, I was wondering if anyone had an issue with the last code in this thread? I am using it and it works (converts the date/time into something more user friendly), however, it's not doing it as expected. Here is my exact code: ['Workflow State Measures':'State Change Date'] = S: TIMST(((NUMBR(DB('}...

Adding another screenshot with the Alias turned off in the Control cube, Groups. The other screenshot had it turned on.

Thanks lotsaram, appreciate the info. What I ended up doing is obtaining the CAMID's for all 870 security groups we have. This was a painful process as they aren't necessarily easy to obtain in a report (at least with the tools available to me). There is something called Cognos SDK or something like...

Hi all, I was wondering if anyone is famliar with or has used any of the processes that you can download from BedrockTM1. Specifically speaking, the process called "Bedrock.Security.Group.Create" - It will create one of more security groups and add it to the server. I was really excited to...

Hi all! I've been working on alternate hierarchies using code on the Prolog tab of a TI process. I have done this a fair amount in the past with just one layer in the alternate hierarchy but using multiple layers is new. I create the alternate hierarchies by looking at the attributes of an "Exp...

THANK YOU!

OMG - Finally got it!! It looks just like what I have above (middle screenshot) where i stated "But I'd like it to look like this:"

It's perfect! Thanks a lot for your continued patience. I wish I could attend some proper training.

:oops: I'm at a bit of a loss. I've been looking on the forum, on the internet, etc. and haven't been able to figure out why I am getting an error. I asked a coworker who recently went through some actual training and she said they didnt' cover CellGetN and CellGetS in class :( I am using the CellGe...

So change the variables to the following? #****Begin: Generated Statements*** vExpense= CellGetN ('SIG Module Cost', vSite, vMPN, vExpenseType, vMonths, 'Expense'); vCostPerModule= CellGetN ('SIG Module Cost', vSite, vMPN, vExpenseType, vMonths, 'Cost per Module'); vCostPerComponent= CellGetN ('SIG ...

Hi all, I was wondering if you knew how to accomplish this. I am exporting into a .csv a multidimensional cube. I want my measures to be across the top - in this case, they are Expense, Cost Per Module, and Cost Per Component. I've accomplished that - no problem. :) However, it's doing it in a line ...

Thankg guys! I don't think a CellPutN will work here b/c my Site dimension has about 10 things in it, my Expense Type has about 15, my Months has over 6 years in it, and the Part Number list has around 8000 parts in it. Thus, I'm not able to point to a specific cell. If I could say something like DB...

I'm not sure why... but I got an email notification that Tomok had replied... but after refreshing, etc., his reply isn't showing up. He didn't send me a PM so I will paste his response here: From Tomok: It depends on what you mean by "publish", and what your expected use of the "publ...

Hi all, I currently have 4 two dimensional cubes that I "publish" (to use Cognos Analyst terminology) (write to a SQL server) on a daily basis. I have these on a scheduled shore and it works great - and is MUCH faster than doing it in Analyst. Now, I'd like to "publish" a five di...