If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Confusion about how to use Dimensional Functions  (Read 7244 times)

dzuser

  • Guest
Confusion about how to use Dimensional Functions
« on: 29 Aug 2015 08:54:04 am »
Hi,
I tried to use Dimensional Functions in FM but i was unable, i was getting the error: The OLAP function **** is not supported.
I modeled the data by using ssas and when importing to FM i was just able to see the cube name.
so i was wondering when and how to use the Dimensional Functions inside the FM for calculations ?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,635
  • Forum Citizenship: +676/-10
  • Cognos Software Muppet
Re: Confusion about how to use Dimensional Functions
« Reply #1 on: 01 Sep 2015 06:47:28 am »
Hi,
I tried to use Dimensional Functions in FM but i was unable, i was getting the error: The OLAP function **** is not supported.
I modeled the data by using ssas and when importing to FM i was just able to see the cube name.
so i was wondering when and how to use the Dimensional Functions inside the FM for calculations ?

Hi,

That's not the way things work with OLAP sources. Within SSAS you model *all* the metadata for the cube, and from Framework Manager you simply define a package for it. If you want to add calculations, the best place to do this is within SSAS.

Cheers!

MF.
Meep!

dzuser

  • Guest
Re: Confusion about how to use Dimensional Functions
« Reply #2 on: 01 Sep 2015 01:47:12 pm »
Thanks a lot for your reply,
just to  clarfiy: in FM when creating measures we have a tab for functions and there is dimensionnal functions in the list like: currentMember.
so just i want to know when we can use them ?
Regards,

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 541
  • Forum Citizenship: +48/-0
Re: Confusion about how to use Dimensional Functions
« Reply #3 on: 01 Sep 2015 07:24:05 pm »
If you're modeling DMR they might prove useful.

dzuser

  • Guest
Re: Confusion about how to use Dimensional Functions
« Reply #4 on: 02 Sep 2015 06:18:44 am »
sorry still confused
But if i cant access  to ssas cubes from FM, how i can use them ?

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 541
  • Forum Citizenship: +48/-0
Re: Confusion about how to use Dimensional Functions
« Reply #5 on: 02 Sep 2015 07:34:56 am »
You would use dimensional functions in FM with DMR, which would be included in whatever packages you want to create and used in the studios.

You would use dimensional functions in the studios with SSAS.   

If you need to enhance your SSAS cube you would need to do that in your SSAS modeling tool.

dzuser

  • Guest
Re: Confusion about how to use Dimensional Functions
« Reply #6 on: 02 Sep 2015 12:23:57 pm »
Thanks a lot