Re: [Axapta-Knowledge-Village] OLAP Cube Month format in AX4.0 or AX3.0

2010-02-16 Thread B S FARTIYAL
: Axapta-Knowledge-Village@yahoogroups.com Sent: Fri, February 12, 2010 1:45:30 AM Subject: [Axapta-Knowledge-Village] OLAP Cube Month format in AX4.0 or AX3.0   We've struck the same issue = month displaying as a number in OLAP pivot table, instead of displaying as alphabetic. i.e. 1 instead o

[Axapta-Knowledge-Village] OLAP Cube Month format in AX4.0 or AX3.0

2010-02-11 Thread george_spl
> To: Axapta-Knowledge-Village@yahoogroups.com > Sent: Monday, 5 May, 2008 1:49:39 PM > Subject: [Axapta-Knowledge-Village] OLAP Cube in AX4.0 > > Hi, > I have a created a cube in AX4.0. It has a dimension of "Time". > The levels are "Year", "Quarter"

Re: [Axapta-Knowledge-Village] OLAP Cube Design Problems - URGENT

2009-07-21 Thread Anitha S
hi.. Try creating a view with these tables and bring in all the necessary fields. Attach the view to the query data source. Now try to process the cube. Hope this helps. On Tue, Jul 21, 2009 at 2:09 PM, Gokhan CAN wrote: > > > I am trying to build an OLAP cube … > > > > I created a Query > >

[Axapta-Knowledge-Village] OLAP Cube Design Problems - URGENT

2009-07-21 Thread Gokhan CAN
I am trying to build an OLAP cube . I created a Query My query is like below. Reqtrans Inventtable Relation Inventtable.itemid = Reqtrans.itemid JoinType 1::1 - Inne

[Axapta-Knowledge-Village] OLAP and Dates?

2009-01-10 Thread kardo_ax
Hi All, What setup other than the OLAP Parameters does affect the dates the cube will show? I have change the start year and End year but still not able to get the year specified although data exists? start year 2008 end year 2009 2009 is not showing in the pivot table!!! One more question, i

[Axapta-Knowledge-Village] OLAP Reporting Problem

2008-07-14 Thread mahesh_axapta
Dear All, I Have Created Query And Attached It To Newly Created cube. I Transfer The Cube successfully. But whenever i click process button It Gives Folowing Error. Method 'processCube' in COM object of class '{A4D49012-F5A5-4d86-8978- 863A41277677}' returned error code 0x80131500 () which mea

Re: [Axapta-Knowledge-Village] OLAP Cube in AX4.0

2008-05-12 Thread Pooja .
day, 5 May, 2008 1:49:39 PM Subject: [Axapta-Knowledge-Village] OLAP Cube in AX4.0 Hi, I have a created a cube in AX4.0. It has a dimension of "Time". The levels are "Year", "Quarter" and "Month". The year and quarter is displayed properly, however for the mon

[Axapta-Knowledge-Village] OLAP Cube in AX4.0

2008-05-05 Thread asm_73
Hi, I have a created a cube in AX4.0. It has a dimension of "Time". The levels are "Year", "Quarter" and "Month". The year and quarter is displayed properly, however for the month it displays the number. e.g. it displays 1 instead of "january". Can anyone please tell me where the possible proble

Re: [Axapta-Knowledge-Village] OLAP ERROR

2007-09-09 Thread Pankaj Gupta
Please go and install the sql server on the client also. anshul On 8/24/07, navneet kaur <[EMAIL PROTECTED]> wrote: > > Hi All , > > I have configured the Sql server for Olap reporting . > At my server end i am able to create , process and view the cubes but when > i access the > cubes from th

[Axapta-Knowledge-Village] OLAP ERROR

2007-08-26 Thread navneet kaur
Hi All , I have configured the Sql server for Olap reporting . At my server end i am able to create , process and view the cubes but when i access the cubes from the client station , I am able to view the cubes in cube defination manager . The cubes are being transfered , processed

Re: [Axapta-Knowledge-Village] OLAP Problem

2007-07-25 Thread Rajnish Goyal
computer 'us-nj-sql1' . Connection to the server is lost. Regards - Original Message From: Arijit Basu <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, 19 July, 2007 11:26:53 AM Subject: Re: [Axapta-Knowledge-Village] OLAP Problem Hi Rajnish, Can

Re: [Axapta-Knowledge-Village] OLAP Problem

2007-07-24 Thread Rajnish Goyal
7;us-nj-sql1'. Connection to the server is lost. Regards - Original Message From: Rajnish Goyal <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Cc: [EMAIL PROTECTED] Sent: Monday, 23 July, 2007 11:33:06 AM Subject: Re: [Axapta-Knowledge-Village] OLAP Problem

Re: [Axapta-Knowledge-Village] OLAP Problem

2007-07-23 Thread Rajnish Goyal
Axapta-Knowledge-Village] OLAP Problem Hi Rajnish, Can you please try the following: Ensure that the user is a member of the OLAP administrator' s group, that the analysis server client part has been installed on the client and the server piece on the OLAP server, that the analysis server client

[Axapta-Knowledge-Village] OLAP Problem

2007-07-18 Thread Rajnish Goyal
Can somebody help me in this Error Method 'Connect' in COM object of class '{B492C386-0195-11D2-89BA-00C04FB9898D}' returned error code 0x80040075 () which means: Cannot connect to the Analysis server on computer 'COMPUTER'. Network error [Internal error] '' . Regards Did you know?

[Axapta-Knowledge-Village] OLAP in AX 2.5

2007-07-12 Thread Matthias Lachetta
Hi there, im starting to collect some informations about Axapta 2.5 and OLAP. Simple Questsion: Does anyone know some good sources about OLAP, OLAP Servers, handling OLAP in Axapta. Every documentaion would be useful, even higher Versions than 2.5 Thanks and regards Matthias L

[Axapta-Knowledge-Village] OLAP: Error while opening Pivot table

2007-04-25 Thread Abdul Kadar
Hi, I am using Ax 3.0 SP4 and SQL Server 2000 SP4. I have made necessary setups in the Analysis Server for data mining. And, I made the requried settings in Axapta as well. I made it for customers. When I try to access the Pivot table, the system is giving the following error:

RE: [Axapta-Knowledge-Village] OLAP - URGENT

2007-01-25 Thread Brandon George
Behalf Of Craig Fidler Sent: Thursday, January 25, 2007 7:21 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] OLAP - URGENT Hi, Anyone come across a problem when installing Analytical Services with an error that occurs with Error Message: OLAP Component

[Axapta-Knowledge-Village] OLAP - URGENT

2007-01-25 Thread Craig Fidler
Hi, Anyone come across a problem when installing Analytical Services with an error that occurs with Error Message: OLAP Components not installed. Regards Craig [Non-text portions of this message have been removed]

Re: [Axapta-Knowledge-Village] OLAP

2006-12-21 Thread navneet kaur
Hi Craig, Craig starting working on the real stuff , i would suggest you to first configure that properly with analysis server on sample data base named as foodmart , that would clear the base concept about the cubes , as i have also started with it first. i Think if u will able to

[Axapta-Knowledge-Village] OLAP

2006-12-19 Thread Craig Fidler
Hi All, I am new to using the OLAP functionality within Ax. IF any one could help it would be appreciated. I want to be able to extract just the credit notes out of the Invoicecustrans table. I have tried putting a range on the query however I get an error when trying to transfer th

[Axapta-Knowledge-Village] OLAP Pivot Table error

2006-09-15 Thread Ramazan Girgin
Hi all, I trying to I set up Olap in my application . I created OLAP cube (SalesAnalysis which was standart in axapta ) . I created cube instance and I process it. Everything is all right until that point. But when I want to see pivot table it gives error like this : Error: Method 'fie

[Axapta-Knowledge-Village] OLAP INQUIRY

2006-05-31 Thread saykai83
Hi All, Anybody could share his idea or experience. How could i achive this in OLAP? 1) Overdue customer payment which is >=120days, >=150days, >=180days... 2) Monthly sales range which is >=5000, >=1, >=2 Thanx in advance Rick Sharing the knowledge on Axapta. Visi

[Axapta-Knowledge-Village] OLAP cube

2006-05-02 Thread Deniz ASLAN
Hi all, I'm Axapta 3.0SP3 user. How can I use decround function in MS OLAP cube? This is my expressions in calculation area: Percent  =  [Measures].[Accept] / [Measures].[Qnty] * 100 Qnty   Accept   Percent    5449   1846   33,8574   -> 34 I want to show

Re: [Axapta-Knowledge-Village] OLAP Servers Synchronize problem

2005-12-27 Thread Realname
Hope you would have registered COM and also u should be a adminstrator /member of administrator for OlaP services Check if analysis server is registered Raj On Tue, 27 Dec 2005 14:08:28 +0530, "Jayaprakash M." <[EMAIL PROTECTED] software.com> wrote : > Guys , > > I have installed SQL Server O

[Axapta-Knowledge-Village] OLAP Servers Synchronize problem

2005-12-27 Thread Jayaprakash M.
Title: OLAP Servers Synchronize problem Guys , I have installed SQL Server OLAP and i am trying to Synchronize the newly created Server  from OLAP Server form(General Ledger-> Setup-> Business Analysis-> OLAP-> OLAP Server->Synchronize button)   into the SQL Server. It is giving me the fo

[Axapta-Knowledge-Village] OLAP - calculated member functions

2005-10-19 Thread nttrehn
Hello! I hope some OLAP - guru is online again. I have a problem with calculated member when making an OLAP - cube. I need to calculate amount of invoices where SalesType = 'Returnitem'. How do I make such function to a calculated member. I tried this: Sum(Descendants([WMDLaskKplPr_Dimension

[Axapta-Knowledge-Village] OLAP cubes Transfer

2005-08-09 Thread Rishi Khurana
Hello everyone, I was working on OLAP. And transferring Cubes. But there is some error as follows:   "Invalid authorization specification"   Please share your experience on this.   Thanks Rishi__Do You Yahoo!?Tired of spam? Yahoo! Mail has the be

[Axapta-Knowledge-Village] OLAP cubes for cost of sales

2005-04-13 Thread James Flavell
Hi everyone, Has anyone done any OLAP cubes for cost of sales analysis/reports? I am considering doing this for a customer and am just wondering if there is any potential dangers/risks? >From what I can see there is an 'OLAPCostValue' on the custinvoicelines table. Can I use this field and if

RE: [Axapta-Knowledge-Village] OLAP: Problem With Importing/Exporting Cube Definitions

2004-11-24 Thread =?iso-8859-1?Q?Johnny_Raadsh=F8j_=28MICROSOFT_BUSINESS_SOLUTIONS=29?=
sage- From: ali_cetin_cetinel [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 7:36 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] OLAP: Problem With Importing/Exporting Cube Definitions Hi, Do you know the way of carrying cube definitions from one analysis server to ano

Re: [Axapta-Knowledge-Village] OLAP: Problem With Importing/Exporting Cube Definitions

2004-11-24 Thread MARTINUS GETTY SANTIKA
Hi, What do you mean did't work, did you find the error or you din't know what to do next? But just for your verification: - Have set up the OLAP server yet? - Have you do transfer cube ? - Have you do process cube? rgds MGS --- ali_cetin_cetinel <[EMAIL PROTECTED]> wrote: > > Hi, >

[Axapta-Knowledge-Village] OLAP: Problem With Importing/Exporting Cube Definitions

2004-11-24 Thread ali_cetin_cetinel
Hi, Do you know the way of carrying cube definitions from one analysis server to another after copying all databases? After copying the databases i could see the cube definitions on the screen but they didn't work. Thanks Yahoo! Groups Sponsor -

[Axapta-Knowledge-Village] OLAP: Problem With Importing/Exporting Cube Definitions

2004-11-17 Thread ali cetin cetinel
Hi,   Do you know the way of working with cubes by using an analysis server which is different from the analysis server that they were first made by?   Thanks Do you Yahoo!? Discover all that’s new in My Yahoo! Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited