TM1 Forum

Actually, the entirety of Chip's site is worth looking at...

Lots of interesting material. I always go back to it when I need to work with arrays in VBA (above the obvious work of course).

Wim

Interesting Lotsaram, thanks for the information.

Perhaps the end result could be moved to a topic in the "Useful code, tips and tricks" subforum?

Wim

Hello, I wrote some code to generalize the process. A loop over the cubes is done, skipping internal control cubes. Application cubes that use control dimensions are not skipped, though. USE THIS CODE WITH CAUTION Subsets and views are created on the fly, and destroyed afterwards. Cube cells are zer...

Hello, I wrote some code to generalize the process. A loop over the cubes is done, skipping internal control cubes. Application cubes that use control dimensions are not skipped, though. USE THIS CODE WITH CAUTION Subsets and views are created on the fly, and destroyed afterwards. Cube cells are zer...

Hi Jonathan

Can you elaborate a bit more on your question? What do you want to achieve in VBA?

In fact, the button itself is a shape, so it can be controlled using VBA.

Wim

Connection successful... :D For others with the same issue... replace Long variables with Integers. In your actual code, but also in the module where you have the list of TM1 API calls. All arguments and returned values should be Integers instead of Long. Good work. Thanks a bunch, I got it now. Wim

Good idea, I will try so.

Hello

If I use Integer's or Short's, I get overflow errors: Arithmetic operation resulted in an overflow.

As thought correctly, the encrypted password does not help w.r.t. the crashes.

I will keep on searching, if anyone else has an idea... welcome.

Wim

Thanks Mike, the results will follow later today or so.

Wim

Many thanks Rebecca! I will try that one out and post my findings.

Regards,

Wim

dubs

Perhaps you can add a few small screenshots to your post (or a new post)? (without sensitive information of course).

Wim

Hi all 1/ Sub pasteSheetAsValues(sh As Worksheet) With ActiveSheet.UsedRange .Value = .Value End With End Sub My bad, sh is an argument in this sub. But I forgot to use it in the line With ActiveSheet.UsedRange that should read: With sh.UsedRange 2/ Call pasteSheetAsValues (Sheet) does exactly the s...

Hi I experienced the same issue lately, and have not yet found the cause or the solution. Here it occurs on my PC with Excel 2003, TM1 9.4 MR1 FP1, not tested with other 9.4 versions. I have an active form, in the columns 3 measures. Normally, 1 of them shows up, the others disappear. Doing an F9 do...

Hello all I have a question regarding TM1 API when used in Visual Basic 2008 Express Edition. I had a working piece of code to log in, which works perfectly in Excel VBA (Excel 2003). My TM1 server runs as a service, to which I connect. It's all locally on my laptop. Below is the code that works up ...

Hi Ian It might be an idea to work with 2 views. 1 for the string measures, 1 for the numeric measures. Create a loop through the measures dimension, and check the type of element. (or a loop through a subset generated by MDX containing the leaf level elements) Then, using SubsetElementInsert, add e...

Regarding the line of code:

For Each sheet In ActiveWorkbook.Sheets

Watch out for Chart sheets. The code will hang in case a Chart sheet is encountered. Use:

For Each sheet In ActiveWorkbook.Worksheets

This is somewhat better code with respect to makeAllSheetsValues and pasteSheetAsValues: Sub makeAllSheetsValues() ' This code saves the active workbook with a new name, then ' cycles through the sheets in the worbook and pastes them as values ' removing all formula Dim saveAsName As String, thisShe...

Regarding makeAllSheetsValues() and Sub pasteSheetAsValues(), see also: http://www.rondebruin.nl/values.htm (and other pages on his website).

Wim

Hello all From time to time, one encounters badly written TM1 rules. So bad that you have troubles to know to which dimension an element in the area definition belongs. You have trouble finding out to which elements the rule applies. For instance, ID numbers that could match in a number of dimension...