: 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
> 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"
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
>
>
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
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
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
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
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
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
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
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
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
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
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?
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
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:
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
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]
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
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
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
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
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
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
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
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
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
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
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
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,
>
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 -
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 thats new in My Yahoo!
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
Get unlimited
32 matches
Mail list logo