TM1 Forum

Hi Nico, check this example below with the food mart db in mondrian. You would adjust it to your schema. best regards, with member Measures.camp_avg as 'AVG( Descendants([store].[Store state].currentmember, [store].[store name]), [Measures].[Unit Sales] )' select {[Measures].[Unit Sales], Measures.c...

yes, seems to be that. It has nothing to do with OLAP.

Jim,

interested in the position of Big Blue in open source? Check this easter egg:

http://www.opentm2.org/

PS: Had to wait some time for an assist like yours ....

normanbobo, you're really tough on this approach... 4) We are using the CROSSJOIN because we want every combination of dimensional elements. I wouldn't use the CROSSJOIN at all. Look at your first post, if even the wizard isn't using it, I wouldn't use it. See the alternative is in this post also. I...

I don't know what the TI wizard is doing, I never use it. You may alternatively use ODBO "MDX query" as a source instead of ODBO cube. Then write a freehand MDX query in the "MDX query" tab similar to the following example for a 3D cube: SELECT {[model].[total].children} * {[regi...

Hi Ed,
this error may appear if Excel reports were edited in two different versions (2003/2007). Restart service, create a new report in one version, publish it. Report should run fine. If you then run one of the corrupted ones then .. Puff! again for all available reports.

Ciao,
Marcus

Hi Robert, I don't understand completely what you*re trying to do or expecting from MEMBER_. [fiscal-year].Members will give you the Principal element names of the dimension elements. Assuming you mention an alias and want to retrieve the principal element name (in this pdata example [année] is the ...

Most of the MDX examples in this forum explain how to create dynamic subsets. A subset belongs to one dimension. Your intention is to retreive values from a cube with an SELECT .. FROM [cube] statement. This is also possible but you need some VBA using the ADO interface. J. Wakefield and K. Blackler...

As a more general question, if I were laying out tables in a schema, how would this intent be captured then? As a attribute of the Location table, which would be a dimension table? correct. An attribute in your location table. Your Attribute "cube" in Palo is representing this table - it ...

At the costumer site no admin ever observed and probably never will observe the log-files. Thus they can be regularly deleted, assuming a regular backup of the log directory on tape is in place! Maybe you're interested in it. - valid for the actual decade (searching for "tm1s201*.log") - W...

This annoying formatting issue also appears with Netegrity Siteminder 6 for access management in place. IIS will create an additional web.config file directly in \wwwroot which is somehow overlaying the original web.config in the standard installation folder. Settings are TM1 9.5.1 64bit, Windows Se...

nice subject! Until today I thought counting "bugs" is done per lines_of_code not area? :D If the relation between location and area is 1:1 - what your example is suggesting - a numeric attribute 'area' for your location dimension would be enough in PALO. You would then calculate density p...

see attached the complete code, in case I oversaw another change. The API declarations I usually store in a separate module.

Marcus

Hi,
is there a possibility to lock users in Cognos Administration after a certain period of inactivity?

Thanks, M.

Do you have more than two cubes in your model? Is your example only an excerpt of the whole model? If not, why do you have two dimensions, measure and account. Measure is a subset of account in your case -option 2. You could use one dimension and one cube. Your "result" reporting you could...

Hi Jim,

if you have no parameters in your process, set the following parameter to 0 (or modify determination of hParametersArray):

hParametersArray = TM1ValArray(pgeneral, iparamarray, 0)

This worked for me with your code.

HTH, Marcus

Security Assignments is correct. "Read" right is enough to let it run. Your error may have a different reason.

Regarding rights for Admin, DataAdmin, SecurityAdmin it is best to read the manuals. Same for system objects (starting with }).

Hi Jim, I don't know if it is possible to force OBI to use one of the tables. Smart OBI should use the detail table automatically if there is no information from the detail table needed for the query. This worked for me in the past. It seems that your query requires information from the detail table...

for MonthToDate (MTD) you could use the following function:

Mtd(Member_Expression)

HTH,

Marcus

Oracle announced OBIEE 11g with the new "Common Enterprise Information Model": http://www.kdnuggets.com/2010/07/b-oracle-bi-11g-game-changer.html?k10n17 The vague part about it is if you take the time to build it But I found Release 10 already was very powerful and intuitive to work with.