TM1 Forum

I think you can create an ODBC connection that points to an Excel SPreadsheet, and then you have to use ODBCOutput to write data do specific Excel Tabs. I have not tried this but I have tried using Excel as ODBC data source for other reasons and it works

You need to execute RefreshMdxHierarchy after the Dimension Hierarchy changes.

This work only in PAX, But you can use it in Perspectives (with error displayed) and upload workbook to websheet: this will work without PAX (but will be difficult to debug). Again one of those stupid IBM "new features". This has been always a limitation in TM1, but since they took the ef...

Hello, In PA 2.0 there is the "TM1PRIMARYDB" function: Returns the primary TM1 server name that the user is authenticated through, even if the user is implicitly logged in to multiple TM1 servers.: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2...

Hi! Here is an issue we have been facing pretty much since we started our project: We are currently loading all data from our TM1 10.2.2 to our DB every night (couple dimensions with 50+ elements), because we cannot narrow our subset of what to export down. Users might change any data at any time, ...

My apology for not mentioning it. It's in Excel. Is this happening in Excel or TM1Web? I have seen some weird behavior like this with websheets with Frozen Panes, so the Action Buttons on the RIght Pane were not working properly so I had to move them on the Left Pane. But in TM1Web, they were worki...

Is this happening in Excel or TM1Web?

Hard to understand your screenshot since it's not English

What do you expect to happen? By Excel Tab you mean you TM1Web Websheet has multiple tabs?
Also by Grayed Out you mean the color or "Locked" so the user cannot update them?

+1

We can check chore active status and schedule in TM1 web prior to 10.2 version. Currently my TM1 version is 10.2.2, I don't see any direct option where I can check these details with out deactivating the chore. Let me know if there any way to figure it out. *.cho files are text files and it's easy ...

Any other changes to be done ? Excel doesn't concatenate strings using the pipe symbol (|). Change your MDX code to not concatenate those strings together. For that matter, I don't understand why you can't make the MDX just one long string anyway??? Sorry thats my bad. I had written a code in TI wi...

You can include both dimensions (Department and Employee) - 2 nested TM1RPTRow columns, and build MDX statements for both Dimensions to be used in the TM1RPTRow formulas. MDX for Employee: ="{FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [employee] )}, 0)}, [employee].[attrib1] = '" & attr...

If you have TI at your disposal and can pass in parameters to identify the location of the cell with the MDX string then obviously the answer is yes. I guess you want this to work without TI? I want to be done without TI, I want an MDX Subset that would include the MDX Statement composed in Webshee...

Thank you guys, I know that excel SUM (with an extra row below active form rows) works, but since we always delete all the Active Form Rows (except the TM1RPTRow), that additional row can be deleted by accident also, so I think I should try creating an MDX subset and use that subset in my DBRW formu...

Try this alternative then: =SUM(INDEX(TM1RPTDATARNG1,,COLUMN())) Assuming the formula will be in the column it is summing, otherwise change accordingly. Damn it, it still works perfect in Excel but not in TM1Web, it includes only the First Row of ACtive Form in the Totals, so I guess eventhough we ...

You can try this: =SUM(OFFSET(TM1RPTDataRng1,0,3,ROWS(TM1RPTDataRng1),1)) Replace TM1RPTDataRng1 with the relevant range per your workbook. The range starts in column A, so an offset of 3 in my example reads from column D. I thought this resolved my issue since in Perspectives it works perfect, but...

gtonkin wrote: ↑Fri Feb 02, 2018 6:14 am You can try this:

Code: Select all

=SUM(OFFSET(TM1RPTDataRng1,0,3,ROWS(TM1RPTDataRng1),1))

Replace TM1RPTDataRng1 with the relevant range per your workbook. The range starts in column A, so an offset of 3 in my example reads from column D.

Thank you George!
This is exactly what I was looking for.

Hi Guys, I have an active form, which is used for Input. I have a few String Measures (user will select through Pick Lists) (Employee Type, Employee Pay Cycle etc) The users want to be able to Filter EMployees by Employee Type, Employee Pay Cycle etc. For this, I am creating Dynamic MDX statement to...

Silw, while it was a big change underneath, I don't recall the end user experience changing much. Biggest change was the change in TM1Web URL API syntax. Also Websheet Navigation Action Buttons, we had to "re-do" them all. Other changes were related to customizations we had done in TM1Web...

The code i wrote earlier will insert only the Direct Parent of the Elements in the subset. But you can modify the code to insert all parents from source dim. Just add an extra loop to find the other parents

You still can use the ELPAR function