TM1 Forum

Hi

Is it possible to have mdx subsets filter by cube data?

can someone please give an example on how to use ti to have a spreadsheet as a datasource which will be password protected to open and sheet protected. I've only ever used csv files.

And is it possible to load data from different sheets?

hi,

with regards to security, is there a way to not allow users to view attributes to elements they have read access to?

I tried setting
}ElementAttributes_dimname
to none but reverts back to write

Has anyone ever managed to automate copying betwen TM1 services...

1. Turbo Integrator Processes
2. Subsets
3. Cubeviews
4. Application folders

either with TI process or excel spreadsheet (that is without having to take down the server)

ok I'm pulling out the last of my hairs! I have a cube where the data is loaded against a date yyyy-mm-dd and there are string attributes held against each date for month and year (ie Apr and 2009/10) i want to be able to send the data to a smaller reporting cube which has month and year dimensions ...

Thanks Scott W


and ...

have a good christmas.

is there such an example?

Has this one stumped you all?

also my MDX statement is well over 255 characters (that I know TI does not like)

never tried MDX via excel. Is there a VBA example you could provide on how to call the data then roll through the 25 lines?

ViewConstruct still not curing.

Ultimately I am trying to create a report (one excel file) which will show 107 top25 views dependant on category. I thought it better to try and populate the top 25 values into a cube for simple DBR formulas.

mmmmm.....

I am looking to populate a cube using ti with the data source being from a filtered cube view which is filtered on top 25. My problem is that ti does not seem to load the data from the filtered view.

Totally appreciate any help