Seeking a way to look up element names of a dimension to replace data in a cube, in Cognos TM1 -

-

my apologies if title sounds vague, here's situation.

there's cube contains 5 dimensions. data contained in cube involves movie title codes classified under different categories.

there's dimension - let's call dim, that's not part of cube, , contains movie title names elements. these title names have movie title codes alias.

i'm looking match movie title codes data in cube movie titles in dimension dim , display movie title names, replacing movie title codes in cube.

i figure can done using turbo integrator, appropriate dimension subset of dim data source. i'm not sure if it's technically possible extract elements dimension subset , use them populate cube based on conditions. there way using ti @ all? sort of appreciated. in advance!

if you're trying think you're trying (and question isn't clearest 1 i've come across), you've got around wrong way.

i'm assuming cube contains strings, , each cell contains movie title code, yes? , want replace title code actual name, derived dimension?

then use view of cube data source.

for each record, on data tab of ti take value , use dimensionelementprincipalname function, passing arguments ( dim'srealname, movietitlecodefromdatasource ), retrieve title , store in custom variable.

the second argument alias of course, , function return principal name which, said, title.

you use cellputs statement overwrite value in cube, since of other data source variables provide set of elements need feed cellputs. (the "contents" of of variables should set other, , variable type string, obviously.)


Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more